Forum

I'm confused. So if I am looking for ticket #12345 it could be on multiple lines of data and you want to consolidate all the information on one line o...

Can you please provide a sample worksheet with an example of the desired results. That way I'm not trying to recreate your spreadsheet.

Hi Jayendra! Your OR(IF) statements already have what to do if the statements are false. Either nix the first IF statement and have the formula rea...

I would probably do a pivot table. I believe with Power Query you can set up relationships between the data on both sheets. Unfortunately I don't know...

I have written a sumproduct formula in the cells under your expected results. Hope it helps! 🙂

Are you looking for something like the file attached? If so, VBA is not required, I simply moved the pivot table fields to columns instead of rows. I ...

Hi Saliha, What exactly are you needing? My first instinct is to just use like an index and match or reference the cell itself (=BOE!F4 in cell F5...

I got the indirect function to work, it looks like there are spaces in your formula, maybe that's your issue? Either way, attached workbook, hope it h...

Hi Marcus! I believe I have the answer you seek! It is an array formula so you will want to hit ctrl+shift+enter if you have excel 2019 or lower.

Could you upload a sample worksheet that shows your problem. It would be easier to help troubleshoot your issue if we can see what you have done in th...

You can't hover over a value and have a second drop down list appear, but you can have dependent drop down lists. This post here should help you get s...

Just right click on your slicer and click "Report Connections" and unclick any pivot tables you don't want the slicer to control. Attached is a screen...

Hi Ahmet! Currently your target.column is set to column 6, you would need to set your target.column to the columns you need. Is it possible for yo...

I found two errors and got your code to work as is. First is, you are referring to code name Sheet 1, but that is tab 2; change your codename to sheet...

Hi Andy, I found this video to help from Mr Excel. You should be able to adapt it to fit your needs. Hope it helps! 🙂