LinkBack URL
About LinkBacks
Hi, In Sheet 1, I do not want rows with #N/a to be displayed. I want only rows which has data. How to modify this formula or write any other formula
Hi, In Sheet 1, I do not want rows with #N/a to be displayed. I want only rows which has data. How to modify this formula or write any other formula
I think you need the formula shown in the attached spreadsheet as shown in cell C1.
The formula isFormula:
Please Login or Register to view this content.
The "Unique" formula only displays matching items. If you prefer to have blank rows where there is no match, i.e., without the #N/A then simply add a "" as shown in the formula located in cell B1.
(Sorry, for some unfathomable reason, I cannot upload your spreadsheet with the correct formula. But you can see the answer in the attached photo. The formula in cell B1 isFormula:Please Login or Register to view this content.
Last edited by TRICKYT57; 01-28-2023 at 06:17 AM.
I am using excel 2013.
I do not want blank rows either
"Currently, the UNIQUE function is only available in Excel 365 and 2021." (30 Nov 2022).Originally Posted by grcshekar
The only way I can think of doing what you want is with the "UNIQUE" function. Hopefully some other user can figure it out for the 2013 version.
Your formula does not make any sense. It is clearly incorrect.
Please explain in words... WHAT it is looking up, where it is looking it up and what the expected results look like.
Maybe add a few expected results, calculated manually???
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
Hi Glenn,
My understanding is that he is looking for the expected results shown in cells C2:C9 from the photo I posted above. Unfortunately he does not have the UNIQUE function in his version of Excel.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks