First I tried Oscar's original, Mijael's, and Zarc Lee's versions - but I was trying to create the "B2" column on a separate sheet. Marvelous work, and thank you! I would like to explain what worked for me and what did not, and ask two questions. If no values in previous cells above are found the COUNTIF function returns a 0 (zero) for that position in the array.ĬOUNTIF($D$2:D2,$B$3:$B$11) returns +IF(MAX(NOT(COUNTIF($B$1:B1,List))*(COUNTIF(List,">"&List)+1))=(COUNTIF(List,">"&List)+1),0,1),0)) The COUNTIF function counts previous values above to make sure that no duplicates are displayed. A beginners guide to Excel array formulasĪrray formulas allows you to do advanced calculations not possible with regular formulas.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |