excel - Need to grab the highest and lowest number in adjacent cells -
in excel, attempting show 1-4 aaaa, 5-7 bbbb, etc
num words 1 aaaa 2 aaaa 3 aaaa 4 aaaa 5 bbbb 6 bbbb 7 bbbb 8 cccc 9 cccc 10 cccc 11 cccc 12 cccc 13 cccc 14 cccc 15 dddd 16 dddd 17 dddd 18 dddd 19 dddd 20 dddd
my logic in head @ whole column , grab highest number of set of adjacent cells match words. grabbing output described above each word.
thanks assistance.
i assume there header row. in c2 put:
=if(min(if(b2 = b:b, a:a))=a2, a2 & "-" & max(if(b2 = b:b, a:a)),"")
it array formula , needs confirmed ctrl-shift-enter. copy down.
note:
if search range static change full column references absolute range, e.g. a:a in case become $a$2:$a$21. make formulas calculate quicker.
Comments
Post a Comment