Forum

If I'm understanding you correctly it's just throwing an AND statement in there and updating the reference. IF(AND(SUMPRODUCT... Hope this helps! Plea...

Can you please attach an example of your spreadsheet so we can see what is going on?

What version of Excel are you on? If you have 365 you can use a combination of sum/unique. Unfortunately, I don't have the latest version so I'm not s...

I would use Power Query to combine the tables and then create a pivot table from the connection (Close and Load to... "Only create connection">Inse...

Extract the month number by converting your month names to dates (set a prefix of "1," and set data type to "Date")>Add Column>From Date & T...

I couldn't find an article or video for it, though Mynda does show this concept in most of the dashboard videos I have seen; the connection of the piv...

There was no file attached, however, as long as your pivot tables are made from the same source data - right-click the slicer>Report Connections wi...

Hi Khunsu, I used it just the other day for inventory. I took a report after some things were received and I needed older totals, I uploaded a spre...

Here (rng.Copy Destination:=WS.Range("A1")), instead of copying directly to the range do a paste special. Unfortunately, I don't know how to paste it ...

Seeing Riny's solution I can visualize the problem better and see where I made my mistake, we're looking at 3 columns instead of 1 (which I knew but s...

Add custom column if [exammth]=1 and [mth]=1 and [mthgrade]="F" then [exammth]=0 and [mth]=0 and [mthgrade]="*"

Personally, I'd use an Index/Match. I have what I believe you are looking for attached.

Hey Shawn! I used a combination of VLOOKUP and INDEX/MATCH in your Variance column. So here's the formula I concocted and what it's doing: =IFER...

I think your problem is your bPrint variable and how it is currently operating. I think what you need is to do the print command inside your loop and ...

Mine was, yes. With that error the just take out the last arguement. #"Added Index" = Table.AddIndexColumn(#"Expanded Custom", "Index.1", 0, 1, In...