EXCEL HELP

Hi guys, First-ever question to the tech team. I work in a small body repair shop that deals principally with a vehicle rental company and looking to cut back on paper use by putting the works proc...

excel

peiyezhu

Bronze Contributor

Oct 24, 2023

https://answers.microsoft.com/en-us/msoffice/forum/all/converting-a-sumifs-to-an-array/5c7f3fab-52bc-45cc-9262-f2f1d1f9bb37
https://techcommunity.microsoft.com/t5/excel/how-can-i-check-yes-for-x-values-in-multiple-columns-in-excel/m-p/3894703#M200728
https://techcommunity.microsoft.com/t5/excel/excel-vba-to-filter-a-table-based-on-multiple-search-criteria/m-p/3812945

sorry, maybe I can not understand you well.
I use sql and database to process data analysis.
And in your situation,You can refer to filter funtion.
If you upload your workbooks with some data and expected result rather than pictures only,I think more brothers will take part in the discussion.

georgekennedy

Copper Contributor

Oct 25, 2023

peiyezhu

Again, thanks for your prompt reply.

I'm out all day (United Kingdom Time), but will look to attach actual files when I return later on today as I'll need to populate the cells with working examples/information.

Thanks again.

Forum Discussion

EXCEL HELP

Resources