=MATCH(1,(Result!O1:O1001=
confirmed with CTRL+SHIFT+ENTER
regards, barry
=IF(E2="","",INDEX(Result!D$2:D$500,SMALL(IF(Result!O$2:O$500=E2,IF(Result!N$2:N$500=A2,ROW(Result!D$2:D$500)-ROW(Result!D$2)+1)),COUNTIFS(A$2:A2,A2,E$2:E2,E2))))
if i wanted to chnage my selection for form(B) or Odds (K)??
If you are experiencing a similar issue, please ask a related question
Title | # Comments | Views | Activity |
---|---|---|---|
After updating data my Excel graphs are showing too many dates | 8 | 32 | |
Excel sheet question | 12 | 28 | |
Problem with Excel and File Size | 7 | 33 | |
Input Data Using a unique ID from another sheet in Excel | 3 | 17 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!