I used index and match but it does not show all cells(Id no.) that contains “excess” value in Line Assignment. https://docs.google.com/spreadsheets/d/1ba7DsJftXcM-jSj8PBO4LE2qh79wRcuk/edit?usp=sharing&ouid=112503748698795281470&rtpof=true&sd=true
I want to get Id No. that contains “excess” value on Line Assignment
It does show Id No. that contains “excess” on line assignment but it does not display all Id no. For example I have 69 ID No. that is excess but it only display 68 Id Nos.
New contributor
Rona Mae Solano is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.