Search results for query: *

Thank you too Miggy for your help. I'm reasonably sure it was system memory causing the file to load erroneous results. I have a lot of apps open and lots of Excel files at once. Thanks again for the help!

Will certainly watch for that. Thank you Skip! Best....

I know what I saw on the first run - it was about half errors. File size is only a guess as to why this occurred. Excel was crashing too. I just ran it again - looking down the rows, I see they are correct. Thank you again for your generous help with my post! Didn't mean for it to drag out like...

My last post shows correct results. The problem is, when I ran the formula and looked at the results, the sheet did not show these results in these columns - they showed incorrect results. This is what I saw. ... 79, for example, has 'plum' (has blank in C79 and a '1' in the section, so would...

I am using manual click & drag down, from A2 and from B2. This is in the file I just uploaded. Results from row 78: SECTOR-1 SECTOR-2 SECTOR-3 DECIMAL orange 0 0 0 0 1 0 0 0 0 .. and from 151: SECTOR-1 SECTOR-2 SECTOR-3 DECIMAL apple CONTENT 1 1 1...

... 79, for example, has 'plum' (has blank in C79 and a '1' in the section, so would be 'orange'). 152 has 'raisin' 'cherry', but has something in C152 and 1s in D, so would be 'apple'.

Yes, as above - 79 and 152.

... 79, for example, has 'plum' (has blank in C79 and a '1' in the section, so would be 'orange'). 152 has 'raisin' 'cherry', but has something in C152 and 1s in D, so would be 'apple'.

Uploaded....http://files.engineering.com/getfile.aspx?folder=6e367853-a158-4fdc-b203-10244e573701&file=Copy_of_MACRO_TO_MATCH_COLUMNS_101116_2.xls

Hi Miggy, Thank you, and yes, I think you are on mark. I thought I was careful to avoid any misunderstanding with my post but I know how things can be misinterpreted. Just to reiterate it in my words. My way of putting it is: (Nothing and a '1' = orange.) (Nothing and only zeros = plum.)...

Thank you for your patience in helping with my post. It is appreciated. I thought for a moment that the macro worked. It returned results all the way to 9000+ rows. Then I noticed, the results were nearly all wrong - a mix of correct and incorrect returns. Sections with the same combination of B...

You said "From then on copy formula from any cell, paste or drag at will." So I used J. What column should I have used?

I entered the formula into B2 as specified. I then copied B2 and pasted it into J2 and dragged it down 2000 rows. Result: #NAME? appears in B2, B3, B4, B5, B6, B7, B8, B9 - and, B18, B26 - and B37, B38, B39, B40, B41, B42, B43 and B44. I do not see how this will apply down to 10000+ rows.

Sorry- yes, I meant to say C or D above. Alt/11 opens the editor. The pane is Modules with the module inside it so this appears correct. OK - I enter the code =EdLow($C2,$D2,B$1) into B2. What then? How is this then applied to the sheet?

I click Alt/11. The VB window opens. In it is the EdLow function. Back to my worksheet, I enter =EdLow($C2,$D2,B$1) into a blank cell and drag it down. It creates a column of 'cherry' with spaces, at various intervals, regardless of what is in B or C.

.. so on a sheet, I have 10,000+ rows, columns A, B, C and D, arranged in sections with the 'SECTOR' and 'DECIMAL' headers. A and B have only these header labels - no other content. Column C may or may not have a value in the cells immediately below the SECTOR-3 header. Column D has either only...

I'm looking at it. I see where it has formulas in A and B, underneath the SECTOR-1 and SECTOR-2 headers, for example: =EdLow($C2,$D2,B$1)

Yes, I see how Alt/F11 toggles to the editor. It contains: Sub raisin2() End Sub I do not see the EdLow module anywhere. I do see, where B2 contains: =IF(NOT(ISBLANK($C2)),IF(ISNA(MATCH(1,OFFSET($D$1,MATCH($E2,Section,0),0,COUNTIF(Section,$E2),1),0)),"cherry",""),"") ..and B3 contains...

I did. Thank you. I have it.

Sorry.... I don't know. I have never created a macro before. Felt is safe to assume - go to Tools/Create New Macro etc.... enter the macro... Yes, I see 'EdLow', but what do I do with the code? Enter it directly on the sheet?