Get results from large data in excel

Hi all,

Every week I insert some large data from an external source in to excel.

I would like some of this data automatically filtered so I don't need to do the filtering by myself anymore or do a copy/paste of the filtered data..
--

I've created a dummy workbook for this.

Sheet2 presents the data I have inserted in Excel
Sheet1 is what I would like to see when incidents are assigned to DUMMYITDESK

with de short descri, symptom, number, etc...

So the thing I when I insert data in sheert 2 the data filtered shoud automatically come in sheet 1

I'm looking for a solution for month's ..

Thanks for your help in advance!

Please Login or Register  to view this content.

And how did you do it?

This is not a the solution I want.. The data in sheet1 shoud appear automatically when I insert new data in sheet2

Sheet1

A5=IFERROR(INDEX(Sheet2!A$2:A$100,AGGREGATE(15,6,ROW(Sheet2!A$2:A$100)-ROW(Sheet2!A$2)+1/(Sheet2!$E$2:$E$100=Sheet1!$B$3),ROWS(Sheet2!$A$2:Sheet2!$A2))),"")

Copy across and down


Sheet1 B3 type Assignment group

You only need to enter data and update.
Accordingly, in your Excel must be loaded Power Query.

Can you check what I am doing wrong? Cannot get any date in my excel when I execute this formula.

Your Excel version in your profile is wrong, it says "Win 10", this is OS.

Tickets Created -O365

A21=IFERROR(INDEX(Sheet2!A$2:A$100,AGGREGATE(15,6,ROW(Sheet2!A$2:A$100)-ROW(Sheet2!A$2)+1/(Sheet2!$D$2:$D$100='Tickets Created -O365'!$B$16),ROWS(Sheet2!$A$2:Sheet2!$A2))),"")

Copy across and down

select Assignment group with dropdown list in b16

Originally Posted by AliGW

@DJunqueira
See post #8.

Last edited by AliGW; Today at 09:57 AM.
Ali
We posted almost at the same time, what should I do now?

Originally Posted by AliGW

No need to do anything, however we didn't post at the same time. Yours was three minutes after mine.
I was just pointing out that the Office version issue had already been addressed.

While I was reading and writing you added the correction, it happens quit frequently in forums, good that we saw the same question almost at the same time...

Simplified formula

Formula:

Please Login or Register  to view this content.

Thanks didn't saw it!

I'm new to this forum so I'll adjust my profile soon

Another question, in my excel sheet I also want to have the word "Problem" filtered (it's a cell containting the word problem) on my first sheet how should I do that?

The outcome should be that all Short description containing the word "problem" should be visible in Sheet1

Thanks in advance!

The following single formula works for Google Sheets but, i guess Excel does not have the "RegexMatch" function;

Please Login or Register  to view this content.

I asked for cells that are containing the word “problem” not starting with problem… so indeed this Left function will not work