All Questions
350
questions
0
votes
1
answer
1k
views
IF multiple criteria matches from two different sheets, return corresponding column value?
I'm using the below IF function to return a corresponding qty using multiple criteria:
=IF(SKU = SKU Range & Price = Price Range,Qty Range,Qty Range)
Instead of returning the qty values that ...
2
votes
1
answer
386
views
Excel: How to use =SUM() with two strings for range?
I need to pass in two strings indicating the two locations of the range. However, SUM wouldn't read the string, but it reads the value of what's supposed to be the indicator of a location.
What I ...
- 167
0
votes
3
answers
9k
views
Extract certain words from strings of text in Excel cells
I have a column of cells filled with a lot of text. I only need one word from each cell. If you look closely you will see that the latter part of each cell says either High, Medium, or Low.
I want to ...
- 15
0
votes
1
answer
101
views
How to select rows that contains data from a column
I want to select data in a row
Name DOB Sunsign Name(Column)
a 1 Ar d
b 2 Le c
c 3 Lr
d 4 CP
Now the new cell must show the following data
Name ...
0
votes
1
answer
121
views
Complicated 'IF' function in Excel
In Sheet 1, I have the following:
If the Due Date is after the Date Submitted, then I want the value in column D of this sheet to be the Detail Status, which is on Sheet 2,
UNLESS the Detail Status ...
- 15
0
votes
2
answers
188
views
Automatically duplicate pivot column, but exclude certain values?
I have a column that I would like to duplicate onto a new sheet. The column can be filtered:
I want to duplicate everything in this column except for the 'Approved' cells (1st option in the drop-down ...
- 15
9
votes
5
answers
12k
views
Combining first two letters from first name and first two letters from last name
I have a spreadsheet of usernames.
The first and last names are in the same cell of column A.
Is there a formula that will concatenate the first two letters of the first name (first word) and the ...
- 93
1
vote
3
answers
12k
views
Looking for formula to search for particular pattern in Excel
I am looking for formula to search for "words" with a particular letter pattern, like INNSA1 or INMAA4 or INPTPB, where the word starts with IN and ends with 4, 1, 6, or B. The words are always ...
- 31
0
votes
1
answer
96
views
Excel: COUNTIFS or Nested IF counting sequential columns
this is my first time posting here so please be a little patient with me. I'm trying to write a formula that will tracked missed scan events (for a package tracking database).
I have several date/...
0
votes
3
answers
5k
views
Use LEFT in sum_range parameter of SUMIF function (Excel)
I have a lot of columns on top of each other, like so:
I would like to find all of the cells in this range that begin with 1a, and then sum up whatever follows. So in this example, we find 1a10 and ...
- 212
3
votes
4
answers
21k
views
Copying Chart to Another Sheet with Updated References in Excel
I have made a chart within a sheet in Excel. Within the sheet, the chart refers to specific cells in the sheet to display (i.e. cells that contain my data points).
I would like to know how to copy ...
- 131
1
vote
1
answer
435
views
Assign Nested Sequential unique numbers for items in Excel Table
I'm trying to generate a unique ID number for a items in a table in excel.
For example: 1.2.4
For each column the number is uniquely numbered based on the text.
For example in the table below would ...
1
vote
1
answer
222
views
How to implement this formula with braces and brackets into Excel
I'd like to use Microsoft Excel to compute this formula to find y :
But I absolutely don't know how to do... It's the first time I see such one.
Could you help me ?
Note : Td2 is a known variable ...
- 255
0
votes
1
answer
95
views
Excel Formula output error
As per below previous question link please find attached , formula is not giving output properly as if i need number inside the bracket only, hope any one can help enter image description here
Split ...
- 23
0
votes
2
answers
109
views
Split data into new column
As per attachment i have column A having name with underscore "_' and bracket " [ " . I need a formula to get answer of column B means I need formula to get id before underscore and inside bracket .
...
- 23