Caveman1964
Board Regular
- Joined
- Dec 14, 2017
- Messages
- 121
Hi,
I have a formula in cell picking up running values. But when nothing is there, its giving me a number. I want it to show blank.
I assume because there is a formula in that adjacent cell.
this is what it shows. Where as E is the customer its picking up from column A, and F is the amount of times that customer shows up from A.
formula in F is referencing E and formula E is referencing another column.
Formula for E is {=IFERROR(INDEX($A$77:$A$3500, MATCH(0,COUNTIF($E$76:E90, $A$77:$A$3500), 0)),"")}
Formula for F is =IFERROR(IF(ISBLANK(E91),"",COUNTIFS(A91:A$375,E91)),"")
Column A is the running entries for customer, so it will have many duplicates.
e79 is blank except for formula in it.
<tbody>
</tbody>
<tbody>
</tbody>
Thank You ahead of time for even reading this!
I have a formula in cell picking up running values. But when nothing is there, its giving me a number. I want it to show blank.
I assume because there is a formula in that adjacent cell.
this is what it shows. Where as E is the customer its picking up from column A, and F is the amount of times that customer shows up from A.
formula in F is referencing E and formula E is referencing another column.
Formula for E is {=IFERROR(INDEX($A$77:$A$3500, MATCH(0,COUNTIF($E$76:E90, $A$77:$A$3500), 0)),"")}
Formula for F is =IFERROR(IF(ISBLANK(E91),"",COUNTIFS(A91:A$375,E91)),"")
Column A is the running entries for customer, so it will have many duplicates.
e79 is blank except for formula in it.
E | F | |
77 | Customer 1 | 4 |
78 | Customer 2 | 5 |
79 | 273 |
<tbody>
</tbody>
This is way out of my league, I'm already in over my head. I would appreciate any of you Gurus help. I don't even know how I got this far, weeks of reading internet and trying. Background of formula. New customers are entered on sheet 2 column L, sheet 3 picks up those and puts them in sheet 3 column A. sheet 3 column E picks up customer and disregards duplicates and places name of customer. Column F shows how many times that customer shows up. Looking at this, its not a good explanation. Hoping one you can see in my formula some way to make column |
<tbody>
</tbody>
Thank You ahead of time for even reading this!
Last edited: