All Questions
56
questions
0
votes
0
answers
6
views
IF AND and conditional formatting question
I am trying to find the right formula for the below situation. Not sure if conditional formatting is the answer or a formula or a combination. I have reviewed guidance for how to use IF and IFS as ...
- 1
0
votes
1
answer
251
views
Excel percentage between todays date and due date
So i need to complete a dashboard and then turn the percentage results into a chart, to see where we are in a Yearly Plan. Lets say the column/the task is "i have to renovate the bedroom", i ...
0
votes
3
answers
359
views
Identify Gap Years Between Multiple Dates in Excel
For example, I have these list of dates (These are of type 'date')
Sept 1, 2010
July 1, 2016
July 1, 2022
The gap years between these dates are 6 years. Another Example:
Sept 1, 2010
July 1, 2012
...
- 2,254
0
votes
1
answer
38
views
I want to merge a text cell together with date cell
I need help writing this formula
=concatenate("(",c9,")"," ",d9)
and i want the result to look like this
(18) 12/31/2021 in the same cell
- 21
0
votes
1
answer
249
views
Multiplying value of one cell with a percentage stored in another cell based on conditional
Hi all seeking some help on the below problem,
I am creating a sheet in which I am creating some weighted forecasting.
I store the company name and inputs in one sheet, along with the relevant ...
- 1
2
votes
1
answer
29
views
Days tracker in Excel
I have a spreadsheet with these 3 columns
(1) starting date (can have a value or be blank, except it cannot be blank when closure has a value)
(2) closing date (can have a value or be blank)
(3) days ...
- 23
1
vote
1
answer
132
views
Create a table in a new sheet with data from two different tables in two different sheets in excel
I am new to Excel and is currently struggling to get intermediate formulas right.
Here is what I'm trying to achieve.
A) I have three sheets,
EMPLOYEE, 2. PROJECTS and 3. ENGAGEMENT
B) EMPLOYEE ...
0
votes
1
answer
227
views
Excel sumif with both horizontal and vertical criteria's
I have the below table
A
B
C
D
E
Posters
1-10
11-50
51-100
101-200
a
£ 0.41
£ 0.41
£ 0.37
£ 0.32
b
£ 0.83
£ 0.82
£ 0.73
£ 0.64
d
£ 24.37
£ 16.67
£ 13.52
£ 10.12
d
£ 0.50
£ 0.50
£ 0.44
£ 0.39
e
£...
1
vote
1
answer
3k
views
Excel formula to split an amount per year depending on expenditure days within a date range
I am in the process of building a formula to split a total cost (in column J) based on start and end expenditure periods that can vary from 2021 to 2031. Based on the days between the expenditure ...
- 143
0
votes
1
answer
203
views
Formula to Find if Number between a Range in 2 Columns and then Offset 1 column
I would like to write an Excel formula that looks at 3 columns and grabs value of the 1st column based on if the search value is in columns 2 or columns 3.
1st Column 2nd Column 3rd Column
a 1 ...
- 21
0
votes
1
answer
49
views
Ammending Equation so that columns A,B do not have to be adjacent to eachother
I have this formula below which sorts data In columns A and B as shown in the image.
The formula is:
=SUBSTITUTE(FILTERXML("<t><s>"&TEXTJOIN("</s><s>'",...
- 765
0
votes
2
answers
76
views
How do i repeat data in Microsoft excel in relative with variable?
Hi I have a List of names and a variable, i need an excel formula or Add-on or an automated method to repeat the names based on the number in the variable.
I need a formula to automate Output column,
...
0
votes
0
answers
482
views
Excel formula to split text using multiple delimiters
I have data string which has characters as , / and (). I need an excel formula that can split text between these three characters and paste in consecutive column. I found formula that can split text ...
-1
votes
2
answers
734
views
How to Get List Of Numbers Whose Students Status is Pass or Failed in Single Cell in Excel
I Want To Get Formula Which Give the Output in Comma Separated List Whose Students Status is Pass or Failed in Single Cell in Excel.
Thank You
- 21
0
votes
1
answer
145
views
Excel - Conditional Formatting to highlight if cell value equals and another cell value is before date
I'm trying to make a conditional formatting formula to highlight the row if EmployeeStatus in Column I equals "Terminated" and if EmployeeStatusDate in column J is before 2/1/2019. Here is what I have ...
- 413