List Array Formula with Criteria skip blanks

[hjforever83]

Hello - Please help. I have been trying to find a formula that can do a list array skipping blanks but not skipping duplicates.

For example:

Category Amount
Banana 2.50
Pineapple
Apple 3.00
Peach 4.00
Apple 2.50
Strawberry 2.50

From this I would like to extract

2.50
3.00
4.00
2.50
2.50

Many formulas that I tried keep skipping the duplicates.

[oeldere]

Filter (empty cells) on column Amount.

After that delete the row(s).

[hjforever83]

Obviously that would be the easiest but I am trying to do an automated report - hence, I need a formula which can pull this information.

[oeldere]

you only interest in the prices, not in the category?

[oeldere]

c2 =IF(B2="","",Count($C$1:C1)+1) and drag down.

f1 =iferror(INDEX($A$1:$C$12,match(Row(),$C$1:$C$12,0),2),"") and drag down.

[FlameRetired]

With above data in A1:B7 array enter this in C2 and fill down until you get blanks.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Please Login or Register  to view this content.

	A	B	C
1	Category	Amount
2	Banana	2.50	2.50
3	Pineapple		3.00
4	Apple	3.00	4.00
5	Peach	4.00	2.50
6	Apple	2.50	2.50
7	Strawberry	2.50