Search results

What makes an 8-digit reference a parent? Is it that if it's in the Org_Checker table and has another entry immediately to its right? Or is it that it isn't in the Level 12 (column L)? If it's the former, this is what I get: which is considerably different from your expected results, so what...

And if they're not, as is the case for a shear rate of 500 for example…? (multiply/divide by 10 until in range?!? - tsk tsk)

In the attached, the next version (Chandoo57767WhatIWantToManage_03.xlsx) several changes: 1. This file can be anywhere, even in the same folder as the .csv fles 2. A new table for you to adjust before refreshing the query: at cell H3 a table headed Intervals. These are the intervals to include...

Yes, and I explained why I think this happens, Excel with dots for decimals can (and does) interpret "24,889" as a number but doesn't recognise "25,02" because the thousands separator is in the 'wrong' place, there should be at least 3 characters after the comma, so it remains a string. It's...

@Lenche08, where are you geographically? Is your Excel using commas as decimal separators and dots as the thousands separator? From your screenshots in msg#36 it looks like it is. My solution recognises that the values in the csv file uses commas as the decimal separator (because I told it to...

@vletm's is working here. Perhaps you've got more than one copy of WhatIWantToManage.xlsb and you're running one that isn't in the same folder as the csv files you're extracting data from? If there are no csv files in that folder you'll get the missing data files error message. This is just the...

In the attached, it's as before except: I've shifted the named range Path to cell H1 I've added a table (a proper named Excel Table (called ShearRates)) at cell H3 I've moved the results table to cell J3 (because varying column numbers in the results played havoc with your data in columns A:F)...

That depends on how often you might want to change things. If it's only very occasionally then we can change those things manually, otherwise it'll be a case of writing it in to the code - perhaps a bit like the path.

That's odd. Are you using the web version of Excel, or perhaps you're on a Mac? I don't know. What version of Excel are you using? OK, try this:

No macro, no vba (it's not a .xlsm file). Right-click the results table, choose Table, then Edit Query…

Was this after trying the new file in msg#4 or before?

1. No need to. You can, but do not delete the entire table. 2. Yes 3. Yes.

My fault. I have updated the attached file in msg#4. Please try again.

That error dialogue shouldn't be trying to look at …\Chandoo57767… it should be looking at what's in cell A13 via cell A13 being a named range in Name Manager called Path. Have you changed something there? Attach you failing file here so I can check for changes?

Be absolutely sure that the path is correct, with no leading/trailing spaces and no final slash character. Copy/Paste that folder path from somewhere if you can. If you still can't make it work, could you quote the actual path here?

In the attached, table at cell A14 of FinalResults sheet. I think that values in cells D9 and F9 should be swapped? I put your 3 csv files into a folder on my system called C:\Users\Public\Documents\Chandoo57767 by themselves and that folder path is in cell A13, which is a single-cell named...

=LET(a,IFERROR(CHOOSE({1,2,3},5*4,10*1,22*0),0),AVERAGE(FILTER(a,a<>0)))or=LET(a,IFERROR(CHOOSE({1,2,3},5*4,10*1,22*0),0),AVERAGE(IF(a<>0,a))) Note that 22*0 does not raise an error. Do you really have formulae with values manually typed in like that?!

Me too. Can you confirm which table you want to add a column to? Looking at your data, there's not a single matching 8-character string between the tables, so I haven't the foggiest what I'm looking for.

Yes! I discovered I'd acquired GROUPBY and PIVOTBY only today - I don't know how long I've had it; a week or two perhaps.

fnStuff is my lack of imagination when naming a function! In the attached, I've added a second group of queries called develop function. In it I've shown 2 versions of the query fnStuff (2) and fnStuff (3). fnStuff (2) is the function converted (back) into a plain query fnStuff (3) is the same...

I don't understand the above sentence! The equivalent for ALL in the slicers is the red cross (which means no filtering):

Note the last message was updated just now.

Test: Function FindCodes(ProdCode, Codes) Set dict = CreateObject("Scripting.Dictionary") dict.CompareMode = vbTextCompare RawCodes = Codes.Value 'Filter out blank codes: Count = -1 ReDim Codes(-1 To 0) If IsArray(RawCodes) Then For Each RCode In RawCodes x = Application.Trim(RCode)...

Why re-invent the wheel?

In the attached, run the macro blah. ps. there is no sheet Travel