Home

Excel

1134 Conversations

Latest Activity

Custom List Message Item

Hi

 

I have an issue where excel is not printing the minor (thinner and inner borders) but prints the major (thicker and external borders) to the printer?  But, when it prints to PDF all the borders come out?  What's going on?

Read More
18 Views
1 Reply
Hi Derryck

Are you able to provide a sample file for us to see? Might give us a better idea.

Cheers
Damien

So here is what I am trying to do. I have 2 worksheets Inventory and Sales. I want to input a SKU (Column C on Sales,Column A on Inv) on the Sales Worksheet and have the COGS(Column G on Sales and Column N on Inv) and Location (Column O on Sales and Colum

... Read More
21 Views
2 Replies

Hello,

 

you can do that with a lookup function, for example Vlookup.

 

Assuming that the first row in the Sales sheet has the column headers, put this formula into cell

... Read More

Start time is 10:48:00.000 (10 - hr 48 - min 00 - secs 000 - milli secs).

Requirement to add huge set of secs.milli secs to the start time

Eg: 01.408 (01 - secs 408 - milli secs).

(Start time) 10:48:00.000 + 01.408 (secs.milli secs) = 10:48:01.408.

To

... Read More
21 Views
2 Replies

Armanath,

 

and if you want to type the numbers as seconds,milliseconds then:

 

 
  A B C
5 10:48:00,000 1,408 10:48:01,408
6 10:48:00,000 61,523 10:49:01,52
... Read More

Hello,

 

make sure the cells are formatted with custom number format h:mm:ss.000;@

 

Next, if you enter a second.millisecond number into a cell, you also have to enter th

... Read More

Hi Everyone, 

 

I am trying to solve a problem

 

Lets say that cells in Column A contain either "loss" "single target" or "double target"

 

In column B I want to enter data manually if the corresponding cell in column A is either "single target" or "doubl

... Read More
45 Views
4 Replies

Hello,

 

well, you could use a formula and overwrite it manually, something like

 

=if(A1="loss",YourFormula,"")

 

Copy down. Now only the cells where column A has "loss"

... Read More

Hi !

 

I have a database and some characters are switched with combinations between other characters and symbols. For example:

 

"Medellín" ,  that is a Colombian city, is written as : "Medell¡"

 

As you noticed, de "í" is replaced by "¡" so i need a fo

... Read More
30 Views
4 Replies

Hi David,

 

You may try

=SUBSTITUTE(<text>,"¡","i")
Best Response confirmed by David Mauricio Gonzalez Roa (New Contributor)

This just started within the last 30 days or so... it appears that when pasting a Pivot Table as values over itself... borders and formatting are now eliminated.  Extremely frustrating as I have the need to distribute Pivot Table data to many corporate us

... Read More
86 Views
7 Replies

Hi Brian,

 

There is a fairly good technique to paste the PivotTable values and formats, but it cost you some extra steps!

 

You can use the Format Painter to grab the fo

... Read More

You can share a Pivot Table with the formatting without the underlying data.

In the Pivot Table Options, Data Tab, de-select the option "Save source data with the file",

... Read More
I can confirm the behaviour and I agree it is silly! I'll make sure MSFT gets this feedback.

Hi, hoping someone can help.

Please see the table below.

I'm trying to combine the "Base Code" and "Variant" column to produce the "Combined" column result. Hope that makes sense.

Basically I want to take the first code in the "Base Code" list and then co

... Read More
77 Views
7 Replies

Michael,

 

would you consider a Power Query solution?

 

Hello,  I have an employee who's sharing an Excel with Macro with edit permissions with a customer (not on our network) and myself (who's on the network). 

1. This file does not allow for Editing in Excel for the customer and only in the browser (See scre

... Read More
51 Views
4 Replies
You cannot edit macro enabled workbooks online, only with the desktop version. https://support.office.com/en-us/article/work-with-macros-in-excel-online-98784ad0-898c-43aa-a1da-4f0fb5014343 Read More

Hi
I've used Excel for years and always used the Enter key for pasting data

 

Recently the enter key stopped performing the paste funtion on a couple of machines, just drops one line instead, so you have to use ctrl + V to paste, which i don't want ... (c

... Read More
139 Views
6 Replies

For me, it works just fine!

There is no option to turn it on/off!

Try to repair the Office from Control Panel.

We went from Office 2010 to 2016 and have 3 users that open .xls files and Save As txt tab delimited files but click inside the name box and change the extension from .txt to .mm and Save the files.  This somehow worked before saving the file in the delim

... Read More
29 Views
2 Replies

Hi Keefe,

 

That's not Excel-specific issue. You may find 3 possible solutions here

http://www.winhelponline.com/blog/double-extensions-files-save-as-dialog-programs-avoid/

... Read More

Hi Keefe

 

I might suggest a quick work around to your issue that you can try (assuming it looks like below):

 

snip_20180219121628.png

 

  1. Rename the file by removing the .txt extension.
  2. The fi
... Read More

Please Help - I'm no Excel expert!!

 

I am trying to improve a log of audit actions, more specifically their timescales for completion.

 

This is the formula I currently have in Cell M2:

=IF(K2="","D",IF(L2="","A",IF(K2<L2,"R","G")))

 

To give some more i

... Read More
183 Views
20 Replies

So the sample is attached.

 

Hopefully a better explanation of what I am trying to achieve:

So..

  • The formula related to Cells in Column M
  • If no date is entered in Column
... Read More

Your criteria seems to have conflicting demands. All dates will eventually laspe when compared to the current date. You'll need to prioritze the criteria. Attahced is a f

... Read More

Try:

 

=IF(K2="","D",IF(L2="",IF(K2<NOW(),"R","A"),IF(K2<L2,"R","G")))

Does anyone have any light to shed on this?

I imagine this is easy, but I need some guidance.

I want a dropdown box to give me a list of suppliers.  When I chose one, other cells in the row will populate with the suppliers phone number, contact person, etc.

 

I know how to create a dropdown list of

... Read More
30 Views
1 Reply

Douglas,

 

If you have a dataset of the suppliers' info, then you can use some lookup functions such as VLOOKUP to lookup in the dataset, and return the info that you wan

... Read More

Hello,

I was given a list of contacts by a user as a text file.  It is formatted loosely as comma delimited values (CSV) but not very consistently.  It has some semicolons inserted after phone numbers, for some reason, and commas after some last names (no

... Read More
32 Views
1 Reply

Hi Marco

 

Maybe try this?

 

  1. In your Excel spreadsheet, go to Data tab > From Text.
  2. Locate and open the CSV file you want to import.
  3. By default it will have Delimited se
... Read More

Hello, I am trying to link a web page to a workbook and when I go to a website instead of going to the tab where I can insert the url: I get a website page. It is hard to explain here are some pics of what I want to do.  The pathway is "data tab" then I s

... Read More
21 Views
1 Reply

Hi Zeta

 

Try this:

 

  1. Go to Data tab.
  2. Drop down New Query menu > From Other Sources > From Web.
  3. Enter your desired URL https://en.wikipedia.org/wiki/UEFA_European_Football_Championship
... Read More

Hi, Is  there a way to enter a number in a cell - "income" then hit "enter" button and it disappears summing all entered numbers in next cell "quantity" ?

83 Views
5 Replies
I don't understand! Where do you want the entered number to "Disappear" to? You could make it "disappear" in many ways - conditional format to set font color the same a... Read More

Hi,

 

A user has the problem that his excel craches daily. I have no clue why excel does that. it just says 'not responding'  and int will not get out off this state. it does  it on random files. small and big and random times. no fixed pattern.  Excel wa

... Read More
119 Views
5 Replies

Microsoft Power Map? I thought that went away entirely with the new BI solutions for Excel. (?)

I too have this problem with MSO.DLL It occures when doble-clicking on a .XLSX -file in the OneDrive folder. Also when trying to open .XLSX-file in the same folder, from ... Read More
I have been having similar issue with Office 365 ProPlus 1801 (build 9001.2138) in that any file I open from a synced OneDriveForBusiness folder, then Excel crashes as be... Read More

I have the attached file and I was able to break down the entire line just missing one, but since the results do not have the extra empty space I don't know how to tell excel to bring from the raw data A2 everything between B2&C2&D2 and F2&G2&H2&I2

Read More
48 Views
4 Replies

Fernando,

 

B2 =TRIM(LEFT(A2,9)) 
C2 =TRIM(MID(A2,10,11)) 
D2 =TRIM(MID(A2,22,4)) 
F2 =LEFT(B2,5) 
G2 =TRIM(MID(A2,101,3)) 
H2 =MID(A2,105,7) 
I2 =TRIM(MID(A2,118,8)) 

B

... Read More

i used to have an Excel Sheet utilizing VBA and collecting data from another sheets arrange it and so on, as a part of the sheet i use it to draw charts by just clicking an VBA button created by me for a certain range of values collected from another shee

... Read More
23 Views
0 Reply

Using data validation, I select 1 of 5 tables to get information on an item, but i cannot figure out how to get the rest of the information in the row in the selected table. H4 has the dropdown and B39 has the data validation, how do i get the rest of the

... Read More
39 Views
1 Reply

Scott,

 

I used some helper cells at C55:D60:

1  
Paving Table_Paving_1
Iowa Table_Iowa
Nebraska Table_Nebraska
NonDOT Table_NonDOT
Rebar Table_Rebar

 

 

... Read More

Is there a way to convert a sum of hours:minutes:seconds to days:hours:minutes.  I'm attempting to do a time study and have added all of the times for the creation of a list of drawings.  Now, I need to convert that to work days + hours + minutes.  How is

... Read More
26 Views
1 Reply

Richard,

 

change the cell format to D hh:mm.

Olá,

Criei vários livros excel (e até documentos word) que vão buscar informação, através de um vínculo externo, às células de um outro livro excel base. Todos estes livros estão em pastas diferentes, alojados num determinado local do meu disco. O que pre

... Read More
22 Views
1 Reply

Através do tradutor do Bing do inglês
Não tenho conhecimento de qualquer VBA ou mesmo aplicativo para fazer alterações em seus documentos com base em alterações ao seu sis

... Read More

I need information on  how to reset the end cell in Excel  365.  My current worksheet has 28K lines of data, but the end cell is at 1048576.  I've tried the obvious select all open rows outside my data, then clear and/or delete, then save workbook, close

... Read More
58 Views
3 Replies

I've seen this too and the best way I've found to consistently fix it is to copy the desired range and paste to a new sheet.

I am usually helping a co-worker with this an

... Read More
Hi Joanna

Are you actually deleting the rows or just pressing delete on the keyboard?
Normally deleting the rows and saving / reopening fixes it

HI Joanna

 

Sorry I'm not quite understanding you (may just be me), what do you mean by resetting the last cell? Are you attempting to delete the cells you aren't using o

... Read More

Dear,

 

I am in search of a formula that can help me achieve the following:

 

I have 2 colums, the first one contains classes, the second one contains items. My goal is to give all the items that fall under a specific class. See the example to make it mor

... Read More
62 Views
5 Replies

Hi Andreas,

 

That could be as array formula (enter it by Ctrl+Shift+Enter)

=IFERROR(INDEX(DATA!$C$6:$C$14, SMALL(IF($B$2=DATA!$B$6:$B$14, ROW(DATA!$C$6:$C$14)-ROW($B$5),
... Read More

Andreas,

 

=INDEX(DATA!C:C,AGGREGATE(15,6,ROW(DATA!$C$6:$C$14)/(DATA!$B$6:$B$14=$B$2),ROWS(B$6:B6)))

Hi, I'm new at this and really not a pro with Excel, so hope someone can help me out!  I'm pulling data from one workbook into another.  The path info is correct, but I'm trying to add totals from columns C, E, G, without adding totals from columns D and

... Read More
54 Views
4 Replies

Hi,

 

do you want "adding totals" or "calculating a median"?

 

Begin by using the AGGREGATE function.

Then its just a matter of selecting your ranges or preferably the fields if using a Table.

Hello. I am trying to figure out how to set exposure levels in solver.

 

For example. I have 200 players with a point projection attached to each of them. I have constraints set up to return the highest projected combination of points among 9 players give

... Read More
18 Views
0 Reply