All Questions
11
questions
2
votes
3
answers
2k
views
Return sum of multiple vlookups
Okay, so I have an issue I'm trying to solve all in one formula.
I have a setup of tables:
How many NFPI (Number of Fruit x Percent Intensity) do I have for Apples?
I need to scan column G of Table ...
0
votes
1
answer
356
views
Align two columns in excel based on 1 criteria
This has me stumped.
if you have data that looks like ABCD:
How do I get it to HIJK?
I am trying to put 2 pivot tables next to each other, so I can compare the two sheets, but when I do it ...
6
votes
3
answers
51k
views
Stop Excel formula from changing when inserting/deleting rows
I'm trying to set up a budget workbook for my personal budget using 13 sheets, 1 for the totals and the other 12 for each month. I cannot for the life of me figure out why the formulas I have change ...
3
votes
2
answers
87
views
I want to count IF both condition are true Logically count by AND excel
I have two Columns both are categorical columns. Like Age_group and Engagement_category.
And I want to get count no. of each engagement_category in each Age_group.
| Engagement_category | Age_group |
...
3
votes
1
answer
328
views
Transpose unique rows to columns while IF statement conditions are met but do not consolidate
Current State:
A B C D E
FG Component FieldKey Cost$ Qty
7120 7120 1220 $4.71 9,783
7120 9907062 1220 $7.80 4,061
7120 ...
3
votes
1
answer
2k
views
Match with interval
I have this table
I have to get the index of column which has the interval that contains 165 (Tier 2).
For example
165 -> Tier 2
15 -> Tier 0
...
I tried to split the text interval in MIN and MAX
...
2
votes
1
answer
565
views
How can I use Excel Formulas to return multiple values using nested IF statements if I need one of the returnable values to be blank?
This is Excel 2016.
I am using a workbook to manage some personal workflow tracking and I have toggles that mark H column cells as "True", "False" or having a zero character string ...
2
votes
1
answer
2k
views
Auto-populate cells in Excel
As you can see in my screenshot,
I have a table called "Payment Details Form" that needs to be filled and
printed for each individual of 100 employees:
In another worksheet, I have a data table of ...
1
vote
1
answer
127
views
Dynamic Excel Formulas For Ranges
How can I make a formula that:
I can vertically drag down on Sheet2...
That TEXTJOINS two arrays (total of 28 vertical cells) of data on Sheet1...
Which after it TEXTJOINS those 28 cells, goes to ...
0
votes
2
answers
163
views
How to TEXTJOIN/CONCATENATE based on constraints for specific no of rows count
I need to concatenate certain attribute value based on the sequence number for specific material number and a formula to automate the process.
I have columns as listed in the below screen shot and I ...
0
votes
1
answer
4k
views
Excel prevent cell and its content from being deleted (no sheet protection)
I have 2 columns in my excel sheet which I want to have protected in a way that you can't delete the cell nor its content. I don't want to use the built in sheet protection, instead I want to use VBA (...