the udf works fine if all the raw data and the results are in the same sheet.
however it gives me blank if i use the formula to get the results in a different sheet.
i should have made this clear, my apologies.
in my final spreadsheet the two columns i am looking for "item" and "frequency" wont be adjacent to each other and nor will the raw data.
any way of achieving this.
I have attached the spreadsheet with formulas already and sheet 1 with results are showing blanks.
thanks in advance.
Reply With Quote
Bookmarks