All Questions
60
questions
0
votes
2
answers
124
views
Calculating percent error of each element of a list given a list of ratios
On Excel/Google Sheets, I have a set of measurements (U to Z for this example) that need to match a set of target ratios (for this example, U to Z must follow a ratio of 2:1:14:7:1:1, so ideally W ...
- 23
0
votes
0
answers
56
views
SumIf formula with multiple columns or criterias
Happy Friday,
I need help with a formula.
I want C30:C35 to be the sum of D2:D10 IF the text in B2:B10 Matches the text in A30:A35
So if A30 says "Apples" and B3 and B4 also say "Apples&...
0
votes
2
answers
189
views
COUNT instances of a text appearing in a range (within a string of said range)
E.g. Number of instances where "Distribution" appears in AN:AN.
AN column contains, for example, "134 Distribution Dept".
I want to count this since it contains the "...
- 19
1
vote
1
answer
2k
views
Curly Brackets added to formula in Excel workbook when downloading from a Google Sheet
I have a Google Sheet Workbook with the following formula:
=IFERROR(XLOOKUP(A8,'Budget Ids'!A2, 'Budget Ids'!C2), "")
The above formula works in the Google Sheet. When I download the Google ...
- 107
0
votes
3
answers
138
views
Calculate the average of last X values in a row, but ignoring a set number of cells
I've been trying hard to solve this but haven't managed yet.
I have this sheet I'm using to keep track of my expenses on a monthly basis and every month I create a new column to register different ...
- 55
-3
votes
2
answers
73
views
Excel/Google Sheets - find matches if in 4 columns
I have 1 sheet with 4 columns (A,B,C,D), with each containing a list of emails.
I would like a way to create a new column of emails if they were found in all 4 of columns A-D.
Does anyone know of a ...
- 3
1
vote
1
answer
82
views
Excel/Google Sheet Adding Duration to Date/Time [duplicate]
I have data relates to time. I have the start date, start time and end time. My objective is to add the end time to the start date/time to return the End date and time.
If the start and end are on the ...
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
2
answers
658
views
Returning Previous Quarter and Year Google Sheets
I am having trouble writing a formula in Google sheets that will return the previous quarter based on today's date.
For example, if I have cell A1 as =today() which is 1/26/22, I would like cell B1 to ...
0
votes
3
answers
226
views
Simplify a Formula
Current Formula:
=IF(SUM(C8:C14)>=8, "10", IF(SUM(C8:C14)=14, "10", IF(SUM(C8:C14)=12, "10", IF(SUM(C8:C14)=6, "6", IF(SUM(C8:C14)=4, "4", IF(SUM(...
- 11
0
votes
0
answers
29
views
Google Sheets: How to use IF, ROW and SUMIF in this specific case
I have a table with the following columns: Branch, Code, Quantity, Code, Quantity, Code, Quantity.
I need a formula that looks for a specific Branch and if the branch is correct summarize all the ...
1
vote
2
answers
188
views
Excel/GSheets add unique flag to reoccuring values in a dynamic list
As a follow-up to the question I posted previously here - Excel/GSheets count unique versus reoccuring values in dynamic list I am looking to count unique values in a list of 30k+ Webinar attendees, ...
0
votes
1
answer
57
views
Excel/GSheets count unique versus reoccuring values in dynamic list
So I have a large data set of webinar conference attendees - about 30k+ rows. I need to write a function (either in Excel or Google Sheets) to determine if each participant is a first time or ...
1
vote
3
answers
61
views
PIvot and Formula function to show unique plus multiple results
I've been racking my brain how to accomplish this but what I am trying to do is use a a pivot table to identify how many IDs only have the 1 skill and by which site.
I also want to show if they have ...
- 53
-1
votes
4
answers
210
views
Spreadsheet - Im trying to find the sum of the top n numbers in two columns
-UPDATED- Answered, thanks for all who helped.
Consider the following Google spreadsheet:
A B C D E
1 John | Bob | Sue | Tony
2 h1 2 | 1 | 3 | 2
3 h2 3 | 3 ...
- 45