# Questions tagged [worksheet-function]

Questions about using in-cell functions/formulas in spreadsheet software.

**0**

votes

**2**answers

19 views

### Excel - Any smart way to take the first line in each cell and move it to the last line?

I have a few sheets that I need to move the first line of each cell to the last line. For example this is one cell:
Chris / Mike / Ralph
Henry / Steve
Mark / Bob
Would become
Henry / Steve
Mark / ...

**0**

votes

**0**answers

19 views

### How to highlight a ColumnName in Excel

I have multiple column names and I want to highlight only those column names in which there are multiple rows containing 'False' as value. So that I can easily find out which columns have 'False' ...

**0**

votes

**0**answers

14 views

### Defining a whole column as a range in COUNTIFS function

I was wondering if someone could help me with a formula. I have a spreadsheet with two worksheets, the first being called "Datasheet". In the second worksheet, I want to be able to select all of ...

**1**

vote

**3**answers

55 views

### Using TODAY in Excel to calculate the next instance of a date within a certain number of months?

Edit to clarify: the date returned MUST be less than 24 months from the current date because this is an expiration date, and the items must expire at the correct time unless renewed. Another way of ...

**0**

votes

**1**answer

25 views

### Even more variables in once cell on excel

Someone very kindly answered this question for me the other week but now I need to make it even more specific:
How can I have a cell display a one of 3 different predetermined figures based on the ...

**1**

vote

**0**answers

12 views

### Excel formula to find date in given range (entire column)

I was actually trying to write a formula to match and find a date in the entire column. So say suppose I have something like this in sheet1:
A | B
--------------------
ID | Date1
---...

**0**

votes

**0**answers

23 views

### How do I do VLOOKUP or INDEX/MATCH for more than one range?

I have been trying to figure out a way to fill up the ratings column (image below) without getting into lengthy formula. I have tried VLOOKUP and 'INDEX/MATCH` but have gotten to a dead end.
In a ...

**0**

votes

**0**answers

16 views

### calculate networkdays between two dates but exclude holiday (however depend on value)

i need excel formula to calculate networkdays that exclude weekend and holiday.
however the holiday depends on the destination
set of data
start date = column a
end date = column b
destination = ...

**0**

votes

**1**answer

33 views

### Google Spreadsheet Formula for Weekend Dates

In Google Sheets, what formula can I use to create a list of weekend dates where each row shows the next upcoming Sat/Sun as follows:
05/18/2019 - 05/19/2019
05/25/2019 - 05/26/2019
06/01/2019 - 06/...

**1**

vote

**1**answer

40 views

### How do i make a conditional formula that will take into account summing and zeroing out within the same row?

I need to write a formula that will continue to sum up deficits and gains across a row in a running total when the total remains a negative number (not out of the deficit) but then gives a running ...

**0**

votes

**0**answers

15 views

### In Excel, how do I change the target range for a Pricetable being queried by an INDEX/MATCH array formula?

So in the image you see two price tables, in fact there will be many more than this. On another sheet there are cells marked "width" and "drop" and when values are entered in these fields, a 3rd field ...

**0**

votes

**2**answers

18 views

### Return Date Once Value Falls Below Criteria in Excel

I haven't been able to find a solution to my current problem so hopefully my request will help others here as well.
I have data arranged as follows(pls see screenshot attached, I am not yet able to ...

**-1**

votes

**0**answers

11 views

### How to MATCH or VLOOKUP all values in a column to match another

I have a dataset of 6500+ values that I need to match with another sheet within spreadsheet.
External Value Column 'F' in Sheet A has values that I need to verify if the same value (long ID number) ...

**1**

vote

**0**answers

11 views

### Excel - Reference Value where multiple conditions are met

I am finding it extremely difficult to translate a simple SQL Style Lookup into excel.
I have data spread about multiple excel sheets which I am trying to combine into one sheet/table automatically. ...

**0**

votes

**0**answers

15 views

### Group by , sort and difference

Please help me derive formula to calculate the difference in Excel after group by and sort by,
In the above excel want to group the columns values "Process Unit,Process Name" and sort by "Time", and ...