All Questions
43
questions
11
votes
5
answers
214k
views
How to combine values from multiple rows into a single row in Excel?
I have a data dump in Excel that consists of annual customer data for two different values. The data was provided with a separate row for value for every year and customer. I.e. it looks like this:
...
1
vote
2
answers
47k
views
How to identify cells in Column A that contain any of the values in Column B
First off, I'm not that advanced of an Excel user. I'm certain Excel can do what I'm about to ask, but I've yet to find a way in any of my attempts or searches.
My question is very similar to https://...
40
votes
17
answers
398k
views
How to get the current column name in Excel?
What is the function to get the current line number and the current column name for a cell in Excel?
7
votes
2
answers
31k
views
Excel-Count number of visible cells containing certain string
I have a sheet in which I first apply a filter to a certain column to show "Unique records only". Now I have a column which contains, for e.g., values like:
Applepie
Applesauce
Crabapple
Banana
Mango
...
21
votes
4
answers
165k
views
Dynamically reference a Named Table Column (via cell content) in Excel
How do I reference an Excel table column dynamically in Excel 2007?
I want to reference a named column of a named table
and the referenced column will vary with the value of a cell.
I have a table in ...
15
votes
5
answers
432k
views
How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?
I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The ...
6
votes
2
answers
9k
views
Conditional concatenate cell content across rows
I have a worksheet with thousands of rows which contain a unique ID A, and one 3 different error codes M. Each individual ID may have 1, 2 or 3 errors. They will always be in the same order.
I have ...
3
votes
2
answers
22k
views
Excel to count number of concurrent sessions based on start/end times
I have a massive set of data that I'm trying to work through. In Column A, I have a username, in Column B I have a session start date/time, in Column C I have the session end date/time.
I am trying ...
3
votes
1
answer
19k
views
Excel Large Function with Duplicates
I'm trying to apply a LARGE function to get the 5 largest values from a column ignoring duplicates. I did some searching around and found some proposed solutions but they don't seem to work for me. In ...
2
votes
3
answers
35k
views
Lookups targeting merged cells - only returning value for first row
I have a master worksheet which contains data that I wish to link to another 'summary' sheet using a lookup.
However, some of the cells whose data I wish to include in the summary sheet are merged ...
1
vote
2
answers
7k
views
Excel INDIRECT function and conditional formatting - highlighting a row
I'm having an issue with conditional formatting using the INDIRECT function. I'm doing something similar to Using INDIRECT and AND/IF for conditional formatting , but the only answer there isn't ...
1
vote
1
answer
204
views
Excel SUMIFS based on two criteria
I would like to total a list of minutes based on two criteria to make a graph after the data is calculated.
The item "Department" (Column C) and "Day of Week" (Column F) are both drop down menus.
I ...
0
votes
1
answer
31k
views
Editing CSV file in Excel always converts number column to scientific notation [duplicate]
I have a CSV file that I'm editing in Excel 2013. In the file there is a column that contains numbers e.g 688087123456789. Everytime I open the CSV file in Excel, it converts the number to scientific ...
6
votes
6
answers
29k
views
In Excel, how to fill down consecutive integers following a pattern 1, 1, 2, 2,
In Excel, I know how to use the "fill down" feature to populate a column of sequential numbers.
I would like to do this but following a pattern like:
1
1
2
2
3
3
Does anyone know how to do this? I ...
4
votes
1
answer
41k
views
Add/Subtract button Excel VBA
Here is an example of my project in this picture
I like collecting, so I am making an inventory sheet in Excel.
I want to make a way that I can click a button and it affects the next, or previous ...