-1

I have a sheet called output, and a sheet for each month a jan, feb etc.

Without vba, is there a formula I can use to extract all information from column A in the month sheets, into column a in the output sheet but keeping only the unique values?

Improve this question
2
  • Ive had plenty of people on here make suggestions that have helped me create or amend formulas. I’m not after “code”, I’m asking if there’s a formula that I can do it with, WITHOUT vba. It may not be possible. Thanks anyway
    – Chris
    Commented Jan 13 at 21:26
  • Why not use pivot tables? If you then choose to you could have just one output sheet (with a month filter) instead of a separate sheet for every month...
    – gns100
    Commented Jan 15 at 16:03

1 Answer 1

Reset to default
0

You might wish to look into the UNIQUE() function.

One call for each Month (array), and maybe have those inside another call to UNIQUE - I have not tried that though.

Ref:
https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e

Improve this answer
7
  • Thank you, but I’m looking for a solution without code
    – Chris
    Commented Jan 13 at 21:27
  • Ahh... missed that "withOUT".
    – Hannu
    Commented Jan 13 at 21:31
  • No worries, cool of you for taking the time anyway - Ty
    – Chris
    Commented Jan 13 at 21:35
  • Update, totally changed.
    – Hannu
    Commented Jan 13 at 21:37
  • 1
    What kind of information do you have in these monthly worksheets, and what do you want the result to look like? Show us an example.
    – MGonet
    Commented Jan 13 at 22:26

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .