Sep 08 2020 10:26 AM
I'm trying to discover if the number sequence in column I equal the number sequence in column B. I know they do, but my =if( statement is telling me otherwise. What can I do to fix this? All cells are set to "general".
Thanks in advance.
Sep 08 2020 10:37 AM
One could be text, another number, not clear from the screenshot. If so, keep in same format or convert when compare.
Sep 08 2020 10:41 AM
Sep 08 2020 10:49 AM
You may apply General to text and number, text will continue to be text and number the number. Perhaps you may submit sample file with couple of records toc heck. Or at least try =ISTEXT() on both.
Sep 08 2020 11:01 AM
I'm afraid I don't understand what "toc heck" is. I had tried putting both columns I and B as numbers and then also as text, but that didn't work either, so I kept them both as general. I applied the suggested =istext(), but that only turned my number sequence into "true".
I appreciate you trying to help me through why my statement is failing me.
Sep 08 2020 11:22 AM
FYI, "toc heck" is a typo for "to check". ;)
You may be dealing with a trailing space at the end of you number in either column.
Sep 08 2020 11:38 AM
ha. Thanks for pointing out the typo. Figured it was something else from excel I knew nothing about :)
In regard to a trailing space, you were correct. Column B had that. Appreciate your input! Curious though, I tried =trim(), but that didn't work. I had to go into each cell individually to delete that trailing space. Any thoughts as to why =trim() didn't work?
Sep 08 2020 12:38 PM
Sep 08 2020 01:04 PM
Thank you for clarifying that. I'll keep this in my back pocket in case I need to use it down the line. Appreciate you helping out!