All Questions
823
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
40
views
Excel trailing zeros
Given this formula in excel =TEXT(ROUND(R22,C13),"0.00")
How do I make so that "0.00" is calculated automatically depending on the number of digits inputted in C13.
Ex1
C13 = 3
and ...
-6
votes
2
answers
53
views
Formula assistance
I am trying to create a formula and cant get it to work.
So -
IF x is >=1000 - 100 however IF x is <999 *80%
So the equation if I entered 1000 would equal 900, but if I entered 800 it would ...
1
vote
2
answers
85
views
Trying to get names from a box on the right to automatically appear in another box when a different box has a value in it
hope the title wasn't too confusing.
this is my project:
I'm trying to figure out how to get the names on the right (NICK-GL) to stack on top of each other at the bottom, when one of the mon-fri ...
user23626448
0
votes
1
answer
115
views
EXCEL- Trying to count specific dates between two but also in specicif Years. Excluding the days before or after the dates asked
I've been looking and searching for this for way too long. I made some dates and added some for tests which I will share.
I'm trying to count days between two dates, leaving it blank if a cell is ...
0
votes
0
answers
51
views
Make auto fill form a part of table
I have a table (table1) then is my data table same as below
Table1
and I have a form then that have a table inside it same as below
Form
I need when I enter the "POD" from "Table1" ...
0
votes
2
answers
54
views
IF Function 2 outcomes
I have a meeting reading sheet with opening and closing readings where I have a simple formula subtracting the closing from the opening to give a consumption reading. I need to add a purchases column ...
1
vote
1
answer
165
views
WORKDAY.INTL not skipping holidays
There's clearly a mistake that I've made that I can't seem to fix. I'm making a table to outline dates for product information (as per screenshot)
My current formula im working with is
=TEXT(WORKDAY....
- 11
0
votes
1
answer
91
views
Dynamically import data from one work book to another with progressive pages
I have two excel workbooks. 1st workbook has all the information I need that are sorted by machines and 3 number inputs following the machines, the inputs for this workbook is created in this format;
...
-2
votes
2
answers
221
views
How to find custom unique values in Excel?
I have the following values in Excel: {"Apple", "Orange", "Orange", "Banana", "Apple}.
If I run the Unique formula on this array, then it will return {&...
- 77
1
vote
1
answer
130
views
Asking Excel to retrieve and match large amounts of data for me from another/same sheet
I have a population of animals. I want to calculate the age the mother of each individual had when that individual was born.
In my spreadsheet with data, I have (among other things I want to test) the ...
- 11
-3
votes
1
answer
81
views
Excel calculates formula even if cell is blank
I have this formula:
=IFERROR(SUM(E9:E20)/COUNTA(E9:E20); 0)*12
Which calculates the values in cells e9:e20 but in some cells I have blank but just the VLOOKUP formula.
I have made a short video to ...
- 17
1
vote
3
answers
1k
views
Formula to Sum the values of a column based on multiple criteria
i need to create a formula to sum the values of a column based on two different criteria's, but here's a trick to it that i cant figure out. This is an example of the table
Here, I have the sum of al ...
- 23
0
votes
1
answer
69
views
Customised XLOOKUP formula
I am trying to Automate an Sheet with an customized xlookup. I am able to figure it out 80% but stuck with the last step. Can any one help?
I have this Formula which I am trying to build using the ...
- 1
0
votes
2
answers
346
views
Excel - get the max value for every 15 mins in a full day data set
I have a set of data like this:
Column A
Column B
00:25:00
22
00:37:00
55
00:48:00
15
01:10:00
23
01:25:00
84
01:37:00
66
01:57:00
33
02:37:00
82
02:45:00
15
02:55:00
22
03:05:00
84
03:17:...
- 11