formula to get data/list based on specific condition

G

gilquenanoviii

New Member
Joined
May 18, 2022
Messages
26
Office Version
  1. 2021
Platform
  1. Windows
Hi everyone, I hope someone can help me with my concern.
I just want to have a formula that will get all the details (the same as what you will see in my table on the right, as i am doing it manually)
I need to get all the details of transactions that has "0" sales (i highlighted it in yellow)
I hope someone would be able to help me put a formula on my summary table on the right that will automatically get all this details when it detects "0" on the sales:
store/receipt number/item number/product name/class/sales/quantity/margin

thank you so much in advance!

342.xlsx
ABCDEFGHIJKLMNOPQ
1StoreReceipt numberItem numberProduct nameClassSalesQuantity SoldMarginRECEIPT NUMBERS WITH SALES OF "0"
2402040201020124043932672019KALEIDOSCOPE COLOURING KIT AFRICAN ADVENTURECHILDREN'S BOOKS-85-143.33StoreReceipt numberItem numberProduct nameClassSalesQuantity SoldMargin
3040201020124043933295076YOU'RE GOING TO BE OKAYNON-FICTION BOOKS-45-121.29402040201020124043943398804PROPHET SONG - SHORTLISTED FOR THE BOOKER PRIZE 2LITERATURE & FICTION BOOKS-115-157.1
4040201020124043940136263HARRY POTTER QUIDDITCH MATCH 2-IN-1 DOUBLE-SIDEDBOOK MERCHANDISE-85-137.82634170TEN MYTHS ABOUT ISRAELNON-FICTION BOOKS0-1-36.14
5040201020124043943398804PROPHET SONG - SHORTLISTED FOR THE BOOKER PRIZE 2LITERATURE & FICTION BOOKS-115-157.1634553GAZA AN INQUEST INTO ITS MARTYRDOMNON-FICTION BOOKS-155-174.92
6634170TEN MYTHS ABOUT ISRAELNON-FICTION BOOKS0-1-36.14402040201020324044003401319THE 30 DAY MBA IN MARKETING - YOUR FAST TRACK GUIBUSINESS & COMPUTING BOOKS-109-155.91
7634553GAZA AN INQUEST INTO ITS MARTYRDOMNON-FICTION BOOKS-155-174.92401826LITTLE HISTORY OF MUSICNON-FICTION BOOKS-139-165.2
8040201020124043945598349MINI BONSAI KITBOOK MERCHANDISE-35-115.21401840LITTLE HISTORY OF SCIENCENON-FICTION BOOKS0-1-38.76
9040201020224043953684477KIDS BOOK ABOUT MONEYCHILDREN'S BOOKS-85-140.87
10040201020224043976425381ME READER DISNEY PRINCESS DREAM BIG 3-INCH BOXCHILDREN'S BOOKS-199-194.76
11040201020224043992848746EAHD DIMIANAARABIC LITERATURE & FICTION BOOKS-58-125.24
1204020102022404399927217815 MINUTE ARABICPRACTICAL & REFERENCE BOOKS-59-124.61
13040201020324044003401319THE 30 DAY MBA IN MARKETING - YOUR FAST TRACK GUIBUSINESS & COMPUTING BOOKS-109-155.91
14401826LITTLE HISTORY OF MUSICNON-FICTION BOOKS-139-165.2
15401840LITTLE HISTORY OF SCIENCENON-FICTION BOOKS0-1-38.76
16040201020324044028395181MY NAME IS BARBRANON-FICTION BOOKS-195-187.03
17395957SAME AS EVER: TIMELESS LESSONS ON RISK OPPORTUNITBUSINESS & COMPUTING BOOKS0-1-46.26
18400921ACT LIKE A LEADER - THINK LIKE A LEADER (UPDATEDBUSINESS & COMPUTING BOOKS-165-182.97
19040201020424044064395607HOW IT WORKS - ELECTRICITYCHILDREN'S BOOKS0-1-30.99
20401249PLANETSCHILDREN'S BOOKS-65-131.08
21404486THE FAIRY TALES OF THE BROTHERS GRIMMLITERATURE & FICTION BOOKS-109-131.25
22040201020424044066394644ONE PIECE OMNIBUS VOL 31 PACOMIC BOOKS-69-130.96
23040201020424044070845740DOG MAN 11 - TWENTY THOUSAND FLEAS UNDER THE SEACHILDREN'S BOOKS-65-128.3
24040201020424044075134887DOPAMINE NATIONNON-FICTION BOOKS-69-131.33
25040201020424044076188213SUDOKU GAMES FOR CLEVER KIDSCHILDREN'S BOOKS-39-119.89
26598349MINI BONSAI KITBOOK MERCHANDISE-35-115.21
27040201020524044136398852FROM STRENGTH TO STRENGTH - FINDING SUCCESS - HAPHEALTH & WELLNESS BOOKS-75-137.52
28040201020524044141398311WILDFIRELITERATURE & FICTION BOOKS-55-124.22
29399153ASSISTANT TO THE VILLAINLITERATURE & FICTION BOOKS0-1-25.35
30692430THE GETAWAY LISTCHILDREN'S BOOKS-55-127.03
31040201020524044157396158FOR THE LOVE OF CATS - A WOODEN MAGNET SETBOOK MERCHANDISE-49-121.71
32040201020624044163845652ICEBREAKER BOOKTOK ] HANNAH GRACELITERATURE & FICTION BOOKS-49-121.32
33040201020624044164846465AL MARHALA AL MALAKIAHARABIC NON-FICTION BOOKS-85-140.25
34040201020624044172199686ARABIC TO ENGLISH VISUAL DICTIONARYPRACTICAL & REFERENCE BOOKS-64-130.13
35040201020624044174845703CURIOUSLY CUTE MANGA ] LOM ARTPRACTICAL & REFERENCE BOOKS-59-124.1
36040201020724044197633889ONE DARK WINDOWLITERATURE & FICTION BOOKS-69-132.4
37633927TWO TWISTED CROWNSLITERATURE & FICTION BOOKS-65-131.61
38634030POWERLESS TIKTOK MADE ME BUY IT! THE MOST EPIC ANLITERATURE & FICTION BOOKS0-1-28.17
39040201020724044204785461ART THERAPY: A MINDFULNESS COLOURING BOOKPRACTICAL & REFERENCE BOOKS-55-121.21
40823809WORLD OF COLOURPRACTICAL & REFERENCE BOOKS-59-121.4
41040201020724044205395030HILDA AND THE FARATOK TREECHILDREN'S BOOKS0-1-21.25
42401075THE 169-STOREY TREEHOUSECHILDREN'S BOOKS-49-124.14
43823401KATIE THE CATSITTER BOOK 2 - BEST FRIENDS FOR NEVCHILDREN'S BOOKS-65-132.13
data sheet
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sort by date Sort by votes
I'm not sure how you got the 402 Store number in first column.
But this seems to work:
Book1
ABCDEFGHIJKLMNOPQ
1StoreReceipt numberItem numberProduct nameClassSalesQuantity SoldMarginRECEIPT NUMBERS WITH SALES OF "0"
24024.0201E+16672019KALEIDOSCOPE COLOURING KIT AFRICAN ADVENTURECHILDREN'S BOOKS-85-143.33StoreReceipt numberItem numberProduct nameClassSalesQuantity SoldMargin
34.0201E+16295076YOU'RE GOING TO BE OKAYNON-FICTION BOOKS-45-121.294024.02E+16398804PROPHET SONG - SHORTLISTED FOR THE BOOKER PRIZE 2LITERATURE & FICTION BOOKS-115-157.1
44.0201E+16136263HARRY POTTER QUIDDITCH MATCH 2-IN-1 DOUBLE-SIDEDBOOK MERCHANDISE-85-137.82634170TEN MYTHS ABOUT ISRAELNON-FICTION BOOKS0-1-36.14
54.0201E+16398804PROPHET SONG - SHORTLISTED FOR THE BOOKER PRIZE 2LITERATURE & FICTION BOOKS-115-157.1634553GAZA AN INQUEST INTO ITS MARTYRDOMNON-FICTION BOOKS-155-174.92
6634170TEN MYTHS ABOUT ISRAELNON-FICTION BOOKS0-1-36.144024.02E+16401319THE 30 DAY MBA IN MARKETING - YOUR FAST TRACK GUIBUSINESS & COMPUTING BOOKS-109-155.91
7634553GAZA AN INQUEST INTO ITS MARTYRDOMNON-FICTION BOOKS-155-174.92401826LITTLE HISTORY OF MUSICNON-FICTION BOOKS-139-165.2
84.0201E+16598349MINI BONSAI KITBOOK MERCHANDISE-35-115.21401840LITTLE HISTORY OF SCIENCENON-FICTION BOOKS0-1-38.76
94.0201E+16684477KIDS BOOK ABOUT MONEYCHILDREN'S BOOKS-85-140.87
104.0201E+16425381ME READER DISNEY PRINCESS DREAM BIG 3-INCH BOXCHILDREN'S BOOKS-199-194.76
114.0201E+16848746EAHD DIMIANAARABIC LITERATURE & FICTION BOOKS-58-125.24
124.0201E+1627217815 MINUTE ARABICPRACTICAL & REFERENCE BOOKS-59-124.61
134.0201E+16401319THE 30 DAY MBA IN MARKETING - YOUR FAST TRACK GUIBUSINESS & COMPUTING BOOKS-109-155.9104E+16395030HILDA AND THE FARATOK TREECHILDREN'S BOOKS0-1-21.25
14401826LITTLE HISTORY OF MUSICNON-FICTION BOOKS-139-165.200634030POWERLESS TIKTOK MADE ME BUY IT! THE MOST EPIC ANLITERATURE & FICTION BOOKS0-1-28.17
15401840LITTLE HISTORY OF SCIENCENON-FICTION BOOKS0-1-38.7600399153ASSISTANT TO THE VILLAINLITERATURE & FICTION BOOKS0-1-25.35
164.0201E+16395181MY NAME IS BARBRANON-FICTION BOOKS-195-187.0304E+16395607HOW IT WORKS - ELECTRICITYCHILDREN'S BOOKS0-1-30.99
17395957SAME AS EVER: TIMELESS LESSONS ON RISK OPPORTUNITBUSINESS & COMPUTING BOOKS0-1-46.2600395957SAME AS EVER: TIMELESS LESSONS ON RISK OPPORTUNITBUSINESS & COMPUTING BOOKS0-1-46.26
18400921ACT LIKE A LEADER - THINK LIKE A LEADER (UPDATEDBUSINESS & COMPUTING BOOKS-165-182.9700401840LITTLE HISTORY OF SCIENCENON-FICTION BOOKS0-1-38.76
194.0201E+16395607HOW IT WORKS - ELECTRICITYCHILDREN'S BOOKS0-1-30.9900634170TEN MYTHS ABOUT ISRAELNON-FICTION BOOKS0-1-36.14
20401249PLANETSCHILDREN'S BOOKS-65-131.08 
21404486THE FAIRY TALES OF THE BROTHERS GRIMMLITERATURE & FICTION BOOKS-109-131.25 
224.0201E+16394644ONE PIECE OMNIBUS VOL 31 PACOMIC BOOKS-69-130.96 
234.0201E+16845740DOG MAN 11 - TWENTY THOUSAND FLEAS UNDER THE SEACHILDREN'S BOOKS-65-128.3 
244.0201E+16134887DOPAMINE NATIONNON-FICTION BOOKS-69-131.33 
254.0201E+16188213SUDOKU GAMES FOR CLEVER KIDSCHILDREN'S BOOKS-39-119.89
26598349MINI BONSAI KITBOOK MERCHANDISE-35-115.21
274.0201E+16398852FROM STRENGTH TO STRENGTH - FINDING SUCCESS - HAPHEALTH & WELLNESS BOOKS-75-137.52
284.0201E+16398311WILDFIRELITERATURE & FICTION BOOKS-55-124.22
29399153ASSISTANT TO THE VILLAINLITERATURE & FICTION BOOKS0-1-25.35
30692430THE GETAWAY LISTCHILDREN'S BOOKS-55-127.03
314.0201E+16396158FOR THE LOVE OF CATS - A WOODEN MAGNET SETBOOK MERCHANDISE-49-121.71
324.0201E+16845652ICEBREAKER BOOKTOK ] HANNAH GRACELITERATURE & FICTION BOOKS-49-121.32
334.0201E+16846465AL MARHALA AL MALAKIAHARABIC NON-FICTION BOOKS-85-140.25
344.0201E+16199686ARABIC TO ENGLISH VISUAL DICTIONARYPRACTICAL & REFERENCE BOOKS-64-130.13
354.0201E+16845703CURIOUSLY CUTE MANGA ] LOM ARTPRACTICAL & REFERENCE BOOKS-59-124.1
364.0201E+16633889ONE DARK WINDOWLITERATURE & FICTION BOOKS-69-132.4
37633927TWO TWISTED CROWNSLITERATURE & FICTION BOOKS-65-131.61
38634030POWERLESS TIKTOK MADE ME BUY IT! THE MOST EPIC ANLITERATURE & FICTION BOOKS0-1-28.17
394.0201E+16785461ART THERAPY: A MINDFULNESS COLOURING BOOKPRACTICAL & REFERENCE BOOKS-55-121.21
40823809WORLD OF COLOURPRACTICAL & REFERENCE BOOKS-59-121.4
414.0201E+16395030HILDA AND THE FARATOK TREECHILDREN'S BOOKS0-1-21.25
42401075THE 169-STOREY TREEHOUSECHILDREN'S BOOKS-49-124.14
43823401KATIE THE CATSITTER BOOK 2 - BEST FRIENDS FOR NEVCHILDREN'S BOOKS-65-132.13
44
Sheet5
Cell Formulas
RangeFormula
J20:J24,J13:Q19J13=IFERROR(INDEX($A$2:$H$43,LARGE((ROW($F$2:$F$43)-1)*($F$2:$F$43=0),IF(COUNTIF($F$2:$F$43,0)>=ROWS($J$13:J13),ROWS($J$13:J13),0)),0),"")
Dynamic array formulas.

 
Upvote 0
awoohaw said:
I'm not sure how you got the 402 Store number in first column.
But this seems to work:
Book1
ABCDEFGHIJKLMNOPQ
1StoreReceipt numberItem numberProduct nameClassSalesQuantity SoldMarginRECEIPT NUMBERS WITH SALES OF "0"
24024.0201E+16672019KALEIDOSCOPE COLOURING KIT AFRICAN ADVENTURECHILDREN'S BOOKS-85-143.33StoreReceipt numberItem numberProduct nameClassSalesQuantity SoldMargin
34.0201E+16295076YOU'RE GOING TO BE OKAYNON-FICTION BOOKS-45-121.294024.02E+16398804PROPHET SONG - SHORTLISTED FOR THE BOOKER PRIZE 2LITERATURE & FICTION BOOKS-115-157.1
44.0201E+16136263HARRY POTTER QUIDDITCH MATCH 2-IN-1 DOUBLE-SIDEDBOOK MERCHANDISE-85-137.82634170TEN MYTHS ABOUT ISRAELNON-FICTION BOOKS0-1-36.14
54.0201E+16398804PROPHET SONG - SHORTLISTED FOR THE BOOKER PRIZE 2LITERATURE & FICTION BOOKS-115-157.1634553GAZA AN INQUEST INTO ITS MARTYRDOMNON-FICTION BOOKS-155-174.92
6634170TEN MYTHS ABOUT ISRAELNON-FICTION BOOKS0-1-36.144024.02E+16401319THE 30 DAY MBA IN MARKETING - YOUR FAST TRACK GUIBUSINESS & COMPUTING BOOKS-109-155.91
7634553GAZA AN INQUEST INTO ITS MARTYRDOMNON-FICTION BOOKS-155-174.92401826LITTLE HISTORY OF MUSICNON-FICTION BOOKS-139-165.2
84.0201E+16598349MINI BONSAI KITBOOK MERCHANDISE-35-115.21401840LITTLE HISTORY OF SCIENCENON-FICTION BOOKS0-1-38.76
94.0201E+16684477KIDS BOOK ABOUT MONEYCHILDREN'S BOOKS-85-140.87
104.0201E+16425381ME READER DISNEY PRINCESS DREAM BIG 3-INCH BOXCHILDREN'S BOOKS-199-194.76
114.0201E+16848746EAHD DIMIANAARABIC LITERATURE & FICTION BOOKS-58-125.24
124.0201E+1627217815 MINUTE ARABICPRACTICAL & REFERENCE BOOKS-59-124.61
134.0201E+16401319THE 30 DAY MBA IN MARKETING - YOUR FAST TRACK GUIBUSINESS & COMPUTING BOOKS-109-155.9104E+16395030HILDA AND THE FARATOK TREECHILDREN'S BOOKS0-1-21.25
14401826LITTLE HISTORY OF MUSICNON-FICTION BOOKS-139-165.200634030POWERLESS TIKTOK MADE ME BUY IT! THE MOST EPIC ANLITERATURE & FICTION BOOKS0-1-28.17
15401840LITTLE HISTORY OF SCIENCENON-FICTION BOOKS0-1-38.7600399153ASSISTANT TO THE VILLAINLITERATURE & FICTION BOOKS0-1-25.35
164.0201E+16395181MY NAME IS BARBRANON-FICTION BOOKS-195-187.0304E+16395607HOW IT WORKS - ELECTRICITYCHILDREN'S BOOKS0-1-30.99
17395957SAME AS EVER: TIMELESS LESSONS ON RISK OPPORTUNITBUSINESS & COMPUTING BOOKS0-1-46.2600395957SAME AS EVER: TIMELESS LESSONS ON RISK OPPORTUNITBUSINESS & COMPUTING BOOKS0-1-46.26
18400921ACT LIKE A LEADER - THINK LIKE A LEADER (UPDATEDBUSINESS & COMPUTING BOOKS-165-182.9700401840LITTLE HISTORY OF SCIENCENON-FICTION BOOKS0-1-38.76
194.0201E+16395607HOW IT WORKS - ELECTRICITYCHILDREN'S BOOKS0-1-30.9900634170TEN MYTHS ABOUT ISRAELNON-FICTION BOOKS0-1-36.14
20401249PLANETSCHILDREN'S BOOKS-65-131.08 
21404486THE FAIRY TALES OF THE BROTHERS GRIMMLITERATURE & FICTION BOOKS-109-131.25 
224.0201E+16394644ONE PIECE OMNIBUS VOL 31 PACOMIC BOOKS-69-130.96 
234.0201E+16845740DOG MAN 11 - TWENTY THOUSAND FLEAS UNDER THE SEACHILDREN'S BOOKS-65-128.3 
244.0201E+16134887DOPAMINE NATIONNON-FICTION BOOKS-69-131.33 
254.0201E+16188213SUDOKU GAMES FOR CLEVER KIDSCHILDREN'S BOOKS-39-119.89
26598349MINI BONSAI KITBOOK MERCHANDISE-35-115.21
274.0201E+16398852FROM STRENGTH TO STRENGTH - FINDING SUCCESS - HAPHEALTH & WELLNESS BOOKS-75-137.52
284.0201E+16398311WILDFIRELITERATURE & FICTION BOOKS-55-124.22
29399153ASSISTANT TO THE VILLAINLITERATURE & FICTION BOOKS0-1-25.35
30692430THE GETAWAY LISTCHILDREN'S BOOKS-55-127.03
314.0201E+16396158FOR THE LOVE OF CATS - A WOODEN MAGNET SETBOOK MERCHANDISE-49-121.71
324.0201E+16845652ICEBREAKER BOOKTOK ] HANNAH GRACELITERATURE & FICTION BOOKS-49-121.32
334.0201E+16846465AL MARHALA AL MALAKIAHARABIC NON-FICTION BOOKS-85-140.25
344.0201E+16199686ARABIC TO ENGLISH VISUAL DICTIONARYPRACTICAL & REFERENCE BOOKS-64-130.13
354.0201E+16845703CURIOUSLY CUTE MANGA ] LOM ARTPRACTICAL & REFERENCE BOOKS-59-124.1
364.0201E+16633889ONE DARK WINDOWLITERATURE & FICTION BOOKS-69-132.4
37633927TWO TWISTED CROWNSLITERATURE & FICTION BOOKS-65-131.61
38634030POWERLESS TIKTOK MADE ME BUY IT! THE MOST EPIC ANLITERATURE & FICTION BOOKS0-1-28.17
394.0201E+16785461ART THERAPY: A MINDFULNESS COLOURING BOOKPRACTICAL & REFERENCE BOOKS-55-121.21
40823809WORLD OF COLOURPRACTICAL & REFERENCE BOOKS-59-121.4
414.0201E+16395030HILDA AND THE FARATOK TREECHILDREN'S BOOKS0-1-21.25
42401075THE 169-STOREY TREEHOUSECHILDREN'S BOOKS-49-124.14
43823401KATIE THE CATSITTER BOOK 2 - BEST FRIENDS FOR NEVCHILDREN'S BOOKS-65-132.13
44
Sheet5
Cell Formulas
RangeFormula
J20:J24,J13:Q19J13=IFERROR(INDEX($A$2:$H$43,LARGE((ROW($F$2:$F$43)-1)*($F$2:$F$43=0),IF(COUNTIF($F$2:$F$43,0)>=ROWS($J$13:J13),ROWS($J$13:J13),0)),0),"")
Dynamic array formulas.

Click to expand...

hello, thank you so much for your response, however, what I need is the full transaction that comes with the "0" sales. the result should be the same as what i have put on my summary table on the right, its just that i did it manually.
 
Upvote 0
gilquenanoviii said:
hello, thank you so much for your response, however, what I need is the full transaction that comes with the "0" sales. the result should be the same as what i have put on my summary table on the right, its just that i did it manually.
Click to expand...
Then you have other filters or discriminators that are different from what you have written in your question, please explain.
Some of your results have sales not equal to zero.

how are these included in your list:


PROPHET SONG - SHORTLISTED FOR THE BOOKER PRIZE 2
GAZA AN INQUEST INTO ITS MARTYRDOM
THE 30 DAY MBA IN MARKETING - YOUR FAST TRACK GUI
LITTLE HISTORY OF MUSIC
 
Last edited:
Upvote 0
awoohaw said:
Then you have other filters or discriminators that are different from what you have written in your question, please explain.
Some of your results have sales not equal to zero.

how are these included in your list:


PROPHET SONG - SHORTLISTED FOR THE BOOKER PRIZE 2
GAZA AN INQUEST INTO ITS MARTYRDOM
THE 30 DAY MBA IN MARKETING - YOUR FAST TRACK GUI
LITTLE HISTORY OF MUSIC
Click to expand...
sorry for the confusion.

Receipt Number = is what i meant by 1 transaction.

in my data list 040201020124043943 for example is 1 transacton that contains 3 Products and 1 of the product there is "Ten Myths of Israel" which is showing 0 sales.

so what i am trying to get on my summary table are the transactions that contains 0 sales, bit i also need to include the full transaction including the other products with it even if its not 0 sales.

so bottomline of what i need to get is:
i need to summarize all Transaction/Receipt number that has 0 sales.

I hope i have explained it well. thank you so much
 
Upvote 0
So, you do not want a list of zero sales. Is what you really want a list of Receipts that have at least one item with zero sales?
 
Upvote 0
gilquenanoviii said:
yes list of all receipts that have at least one item with zero sales.
Click to expand...
Okay, this is likely possible using a formula similar to what I have above, but much more complicated (for me, there maybe other in the forum that can do it elegantly). But, it would be a lot of my time. Hopefully someone will continue.

If you have Excel 365 functions this would be much easier.
 
Upvote 1
awoohaw said:
Okay, this is likely possible using a formula similar to what I have above, but much more complicated (for me, there maybe other in the forum that can do it elegantly). But, it would be a lot of my time. Hopefully someone will continue.

If you have Excel 365 functions this would be much easier.
Click to expand...
thank you, I appreciate your time sir. hoping someone can help me out with the formula needed. I am using microsoft office professional plus 2021.
 
Upvote 0
Well, with 2021 you can use the FILTER function, but I had problems with my formula and can't get it to work. So, yes, I hope someone works on this as I'd learn too,
You may want to update your profile to show all the versions you use. Best Wishes.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Create Named Range for each column based on column heading text.
Replies
5
Views
108
Cubist
Cubist
RAJESH1960
  • Question
Edit and correct Index, Countifs... formula.
2
Replies
18
Views
869
RAJESH1960
RAJESH1960
N
  • Question
VBA code to filter data from cell and save as filtered data into a new workbook with specific file name based on cell value
Replies
0
Views
1K
nikhil0311
N
N
  • Question
Counting specific entries based on various conditions
2
Replies
13
Views
485
Newbienew
N
Z
  • Solved
Formula to create a hierarchy for a list of employees
2
Replies
18
Views
380
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,215,108
Messages
6,123,129
Members
449,097
Latest member
mlckr

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top