Forum

You can do an IF formula using symbols in a separate cell in your sheet and then reference that helper cell with a text box to make your arrow dynamic...

I'm going to preface this by saying I could be wrong and may be corrected, I'm ok with that. When approaching a problem like this I think, if I we...

You should still be able to only use one item of the list without populating the whole list; in the same way you can use the months of the year for ju...

I would send your query to the data model and do a pivot table. Unfortunately, I don't have full access to the data model on my current computer so I ...

I'm sorry, Justin, this was so long ago I'm trying to refresh my memory. I think I have most of the pieces, but where are you getting your original da...

In PQ highlight your 3 AV click add column>in the group "From Number", Standard>Add. Do the same for your PV columns. Highlight your AV & PV...

I have a couple of thoughts: one is to do calculated cells that aren't part of the Pivot Table. I do think, though, that your best option would be to ...

Try this. I changed the formula in f8 to use MAX instead. The formula was getting long and since you only have 1 PO number in your example I just used...

Hi Steven! Is this what you're looking for? 🙂

Are you looking for something like the attached file? I used SUMPRODUCT as it can handle arrays.

When you lock your worksheet there is a list that pops up, find Insert Rows and check it (If there is anything else you want to allow while the sheet ...

If you don't want to merge, just group all rows and List.Count then expand. See attached. Either way your golden. 🙂

Hey Femco! Just group your table by Class and add an index column to the table and an index to the grouped table, then combine your expanded column...

I corrected your named range (You just needed an ending cell address), then whenever hard keying in your sales range cells just use your named range, ...

Nothing attached, when uploading, don't forget to click 'start upload' and wait for the grey check mark. From what I am seeing though, your formula =C...