Forum

Hi Jim, Please read Please attach your workbook. Without your workbook it makes it more difficult to visualize and recreating your data will ...

Hi Pedro, Please read this You need to attach your workbook so we're not wasting time recreating your data. Regards Phil

Hi Vivian, Please refer to this A topic title of Help doesn't tell us much! and as Purfleet said, you should always attach your workbook. ...

Hi Steve, You can share a file on OneDrive without needing to email anyone. Right click the file -> Share make sure at the top of the pop-...

Hi Guys, If you need to share large files use OneDrive or DropBox. Phil

Hi Sajid, Please attach your workbook so we don't have to recreate your data. Regards Phil

Hi Luna, I can only read the Capture3 image, the others are too small or contain no information. If you haven't changed your queries then someth...

No file attached. Instructions on attaching a file

Hi Joe, Please always supply a workbook with sample data. I'm guessing as to whether your serials are stored as text or numbers. If you have se...

Hi Catherine, You didn't say what version of Excel you have. In modern versions of Excel, Power Query is built-in, not a separate add-in. You...

Hi David, In Excel 2019 Power Query is built-in, not a separate add-in. You'll find it on the Data tab, in the Get & Transform Data section....

Hi Christy, Can't help you without your workbook, please attach it. Phil

Hi Arunachal, at the start of the Validation() sub just remove the line Application.Calculation = xlCalculationManual Regards Phil

Hi Rebecca, The MATCH function requires an exact match when the last parameter is 0 and in my blog post I used it this way to look up values that I...