All Questions
693
questions
4
votes
1
answer
166
views
Consolidate Data from Multiple Columns into One Column
I have a dataset that looks something like this:
Customer
Col1
Col2
Col3
Bob
111
2221
Michael
112
Anna
113
2223
Rachel
114
2224
334
Person5
115
I'd like to put all data into one column, ...
0
votes
1
answer
79
views
In Excel is there a way to “turn on and off” the =min in a formula?
I am creating a budget spreadsheet in Excel and in some instances I will need the formulas in the spreadsheet to include the =MIN and in some instances I won’t. For example, the formula is:
=MIN(...
0
votes
2
answers
68
views
Copy paste the values of cells from Excel
I want to copy paste the cell values what we see post pressing F9 in a cell into word. Is there any short and quick way to do this?
For example - if I have a formula:
=AVERAGE(E12/H12,E11/H11,E10/H10)
...
0
votes
1
answer
91
views
How to compare two columns in Excel with a conditional IF statement?
I have three columns that have some expense figures: Actual (column A), Budget (column B), Variance (column C):
For these expenses, if Actual is greater than Budget, I want the variance column result/...
0
votes
1
answer
116
views
Formula for Matching Header to Value
This is a question that I may have difficulty explaining, so bear with me.
On one sheet I have a column which has several cells, some of which are blank, some that have a single value, and some that ...
0
votes
1
answer
68
views
How to count the number of cells that contain certain text while excluding cells that start the same but end different
In our company, the truck numbers in our database all start with "TK" A regular truck would be "TK123" for example. We also have stipend trucks and these all start with "TKPB&...
0
votes
1
answer
277
views
How to Autoincrement the Column index number by dragging VLOOKUP formula down
I need to drag a Vlookup down and have the Column index number in to increase by 1 every row I drag it down.
So for example:
Row 1:
IF(VLOOKUP(A2,'Jan 2024'!$D:$BP,**35**,0)<=0,"IGNORE",...
0
votes
3
answers
152
views
How to count for between two dates in 2 colums with different row in Excel
I have a spreadsheet with 2 columns with dates and one with a Room #:
Date In
Date Out
Room No
2/3/2023
2/5/2023
Room 1
2/5/2023
2/8/2023
Room 1
2/8/2023
2/10/2023
Room 1
3/23/2023
3/26/2023
Room ...
0
votes
1
answer
67
views
Why am i having a #value in my index excel formula?
I am trying to create a formula With Index excel but there ia something wrong and i can't figure it out , below is my formula
=INDEX(TABLES!$D$98:$S$189,MATCH(1,($C$3=TABLES!$D$97:$S$97)*($C$4=TABLES!$...
1
vote
1
answer
4k
views
References to blank cells become 0's
I have a spreadsheet in excel where I need to make some references to an area in another spreadsheet. I simply use ='EARTH'!B9:N323, which is an area mixed with some columns of text and others of ...
0
votes
1
answer
81
views
How to stop numbers from automatically opening hyper links in Excel?
So I have ID numbers that I hyper link to a website. It's automatically hyperlinking the whole cell, preventing me from editing the text by double clicking the cell.
For example, let's say I have ...
0
votes
0
answers
59
views
Formula to Round Down Number in cell
I need to round down the highlighted numbers in Column Q of the attached screenshot. I currently have formula of P/F starting on Cell Q5 through Q46. I am diving the quantity on hand for each part ...
0
votes
1
answer
519
views
Excel Help - If two cells meet a certain criteria input a value into another cell
I'm a bit of an excel beginner so apologies in advance.
I need my worksheet to automatically input a price into a specific cell.
I have a table in one sheet which has tables for each product brand and ...
0
votes
2
answers
194
views
Round each instance in Sumproduct before sum
I am trying SUMPRODUCT Formula on lets say Column A and Column B. Column A has Patient referrals and Column B has percentage referred for each hospital. I am using this syntax:
ROUND(SUMPRODUCT(A1:A10,...
-1
votes
1
answer
71
views
How to generate a table of names based on complicated criteria in Excel
Screenshot:
Hi experts,
I am trying to make a table in Excel that can generate a "Doc #" for each day of the month (for Monday to Friday only) based on availability. I've included a ...