Forum Discussion
help with formula & functions (no Macros & VBA)
Hey all, I've created a sheet that has the following columns: (A) dates, (B) names, (C) phone numbers, (D) free text & (E) Status (done or closed). The first row (frozen) contains the title of e...
Hey mtarler. Thank you for the reply (sorry It took me a while to get back).
I tried to use your file as a sample, but one I open it and try to use the method you offered I get an error (invalid). So I know for fact I'm doing something wrong.
Also, I'm using two sheets in the same workbook. So in one there's my data and the other I use it as an "index".
I tried to use your file as a sample, but one I open it and try to use the method you offered I get an error (invalid). So I know for fact I'm doing something wrong.
Also, I'm using two sheets in the same workbook. So in one there's my data and the other I use it as an "index".
what version of Excel are you using? In particular are you using Excel 365? The workbook I sent uses FILTER() function which is only available in Excel 365.
If you ARE using Excel 365 then please explain more what isn't working or what you see when you open my sample.
If you ARE using Excel 365 then please explain more what isn't working or what you see when you open my sample.