Home

Excel

1131 Conversations

Latest Activity

Custom List Message Item

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
134 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
28 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
181 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?

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
13 Views
0 Reply

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
24 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

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
40 Views
3 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

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
31 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
117 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
47 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

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
61 Views
5 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.

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
25 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, 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
68 Views
6 Replies

Michael,

 

would you consider a Power Query solution?

 

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

I would like to insert SAMPLE watermark to a spreadsheet. I saw an example of inserting DRAFT and CONFIDENTIAL. Wasn't sure if this would be the same or not.

36 Views
1 Reply

Hi DC Green

 

There's no direct way to create a watermark in Excel however this Microsoft Support article will help you with a workaround.

 

https://tinyurl.com/y8f6xazu

... Read More

Hi! I am trying to create a formula that calculates accruals for vacation and sick time but stops calculating once 40 hours has been reached. Any ideas on how to create this formula please?

28 Views
1 Reply
Hi there

Do you have a spreadsheet template in mind that you can show us? It will help to see how it is laid out.

Cheers
Damien

I work in an office  with 3 work stations , all on windows 10 .

2 MS office 2010 and the last one MS office  2013

All connected to a Network-attached storage (NAS)

One of the most important excel files ( stored on NAS ) was crashed ,with a message that it

... Read More
30 Views
1 Reply

Is the NAS backed up? Retrieve a backup copy.

 

If an XLSX file truly crashes and becomes corrupt, the restoration process will fail. Some of the data may be recovered by

... Read More

On worksbook A I want to be able to enter some data, at the same time I want some of that data be reflected on workbook B. I create this formula    =SUM([Book2a.xlsx]Sheet1!$C$4)     and it is working but is there another formula that might work on Share

... Read More
22 Views
1 Reply

Your data in Workbook A should be in a Table. Use CTRL+T to convert a range to a Table. Then in your Workbook B you will reference the Table instead of a Range. As the Ta

... Read More