All Questions
58
questions
1
vote
2
answers
53
views
Counting elements based on three criteria located in two columns
I wanted to ask you if there is a way to perform a count by applying formulas directly, without having to resort to the filter option, through the COUNTIF or COUNTIFS function.
From two criteria found ...
0
votes
1
answer
55
views
Is there an excel formula to calculate all "like" entries from two criteria across two cells?
I'm putting together a personal budget and have added a tab to track daily expenses. I've allocated a "code" against a type of expenditure, and then a "sub-code" for more specific ...
0
votes
1
answer
9k
views
XLOOKUP Function Disappeared
I have been using xlookup for several months across several files just fine but today it stopped working across all Excel files. I invested a lot of effort moving from vlookup to xlookup and now it's ...
1
vote
1
answer
921
views
How to return the value of one cell based on the max of multiple ranges of other cells in excel?
I am a bit new to excel and have a spreadsheet where I am trying to use the MAX of a range of cells in order to return the name of the row that that MAX belongs to. So, I have a cell returning the MAX ...
1
vote
2
answers
72
views
Please help me stop Excel 365 enterprise from changing my text formatted cells into formulas
I have a spreadsheet where I need to use strings that contain a couple of dash/ minus ( - ) signs in cells, but it will not stop truing to recognize them as formulas! I have already formatted the ...
0
votes
2
answers
135
views
VBA or Function to see if a serial number has been used
I have a workbook that contains the issued serial numbers for components. Column A has the serial number and Column B has the part number. I want to have a verification in column C if the serial ...
0
votes
2
answers
7k
views
Cell referencing change with filter
I am quite new to Excel and just figuring out how to do things. I have a question about cell referencing between sheets.
Say I have on Sheet1 this table:
DIMENSION VALUE
X 0
Y 1
Z ...
0
votes
2
answers
268
views
Filter columns based on starting string, read number from filtered cells and perform arithmetic operation to generate summary of two rows in Excel
I am having a Project and resource allocation report. I need help in generating the formula to display summary on the right section of the report.
Here're the specifications of my report:
Column A ...
0
votes
3
answers
432
views
Excel - Filter rows based on starting string, read number from filtered rows and perform arithmetic operation to generate column summary
I am having a Project and resource allocation report. I need help in generating the formula to display summary in the bottom section of my report.
Here're the specifications of my report:
Column A ...
1
vote
3
answers
309
views
Microsoft Excel: Use OR Logic and multiple ranges with COUNTIF
I am analysing some form responses and want to count if someone has put a specific answer in a range of different boxes. I have attached an example to explain the logic.
When filling out address ...
0
votes
1
answer
125
views
Need Help for Inventory Tracking System with XLOOKUP
Sorry for not wording the question better, but I'm a bit confused how to put it. Please feel free to edit or suggest a better title!
I am making an inventory system for a collection of rental ...
0
votes
1
answer
164
views
Excel: How to change column to average based upon unique identifier
I have a situation where for a certain daily date range I have 5 different columns of data which are for 5 different pieces of equipment. I'm trying to set up a calculator where I can select the piece ...
0
votes
3
answers
165
views
IFS Formula With Exact Digits
I am trying to create an "IFS" formula where if the number of a cell has 2 digits, then x, if 3 digits, then y, etc. The numbers are coming from another table with VLOOKUP.
So, if the ...
0
votes
1
answer
50
views
Look for Date values in embedded in strings
I have a value in a cell that might have a 2-digit month and 2-digit year value embedded in it, and I need a function that would return TRUE if that is found.
Sample input data: sCa!1220LB6qHZbCnsEE ...
1
vote
1
answer
2k
views
Filter function with IF statement in 1st parameter to perform fill down multiplication OR division
Link to my previous related question for more background if needed: Transpose unique rows to columns while IF statement conditions are met but do not consolidate
My table headers start on row 20 ...