Forum

I removed the step #"Changed Type" from both queries, that step usually has hard typed column names in it.

Hi Howard, Change your J1 formula to: =IF(Recon!C10=0,"(blank)",MAX('Raw Data'!M:M)) This way, the filter value we need is always in J1. Try ...

Hi Tony, Put this formula in V4 and copy the cell to V10: =RANK(T4,T$4:T$10,1)+COUNTIF(T$4:T4,T4)-1 This will create a rank without duplicate...

Try this code: Sub Macro1() Dim Tbl As ListObject Set Tbl = ThisWorkbook.Worksheets("Schedules").ListObjects("BILLS") Tbl.Range.AutoFilter F...

Indeed, the last step of the query returns error, because {0} in the function return the result as a record typ. If we remove {0} from function, we...

If you want to have multiple matches, remove the {0} from the function, this is what refers to the first match only. When you work on the look...

Velouria said I still can't see why an autofilter wouldn't suffice if you're only looking in one column (as the original post says, although the subs...

That will not work, as you clearly mentioned that the PO might be on a different row in the second file, a UNIQUE identifier is required. I tried to u...

Yes.

First, I add the lookup table as a query, just like any other table, ad I perform the operations I need to get the result I need: added a column with ...

Hi Gary, You can use a dynamic way to expand the table, this way any new column added in source will automatically show up, without manual editing....

Well, that's what your test just did, if the keyword is in lookup table, there will be a value return, it will display null if no match found. It ...

I can see you are already using special cells, maybe you want to use instead: .SpecialCells(xlCellTypeVisible) Or, you can just add a new condition...

Hi Lee, In the Changed Type step, change from type time to type number. The grouping will work.

Hi Eric, The easiest way is to use Power Query to take the data from those 2 files and combine the information, a visual basic solution is much mor...