Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 435
- Office Version
- 365
- Platform
- Windows
Hi,
I have a column of data (DZ6 to DZ20) from cells with formulas which results in some with data and some with blank cells. The formula below is working for text and sorts the data ascending removing blank cells and places results in cells DZ300 onwards, but I have other column with numeric and blank cell results.
When I use this formula on the numeric cells it results in an error. I'm sure it's something to do with text versus numeric in the code, but can't work it out.
Can anyone advise what I need to change in the formula to remove blanks and sort the cells with data in descending order?
Any help is always appreciated.
=IFERROR(INDEX(DZ$6:DZ$20,MATCH(0,COUNTIF(DZ$6:DZ$20,"<"&DZ$6:DZ$20)-SUM(COUNTIF(DZ$6:DZ$20,DZ$300:DZ301)),0)),"")
I have a column of data (DZ6 to DZ20) from cells with formulas which results in some with data and some with blank cells. The formula below is working for text and sorts the data ascending removing blank cells and places results in cells DZ300 onwards, but I have other column with numeric and blank cell results.
When I use this formula on the numeric cells it results in an error. I'm sure it's something to do with text versus numeric in the code, but can't work it out.
Can anyone advise what I need to change in the formula to remove blanks and sort the cells with data in descending order?
Any help is always appreciated.
=IFERROR(INDEX(DZ$6:DZ$20,MATCH(0,COUNTIF(DZ$6:DZ$20,"<"&DZ$6:DZ$20)-SUM(COUNTIF(DZ$6:DZ$20,DZ$300:DZ301)),0)),"")