Can you provide a mock up of the data of how it would be input and what you would want the output to look like.? Its much more efficent than us guessi...
Rather than VBA cant you use conditional formatting? If i have understood the requirements correctly, somthing like this =INDEX($B:$B,MATCH(MAX(...
What version of excel do you have?
So you want the whole setence bold? You cant do this in a formula, you would need to either manually bold the cells or create a UDF to do it.
I dont think the dates were formatted as dates - i did text to columns on the date columns and your formula worked. Maybe a slightly easier formula...
What is the critieria? How do we know what words you want to be bold?
Slightly different take on it - might help with non numbers in chinese? This Macro loops through each cell in a selectoin and checks if each charac...
It will only find the first occurrence but this might help =INDEX(E2:E8,MATCH(H3&"*"&H4&"*",C2:C8&D2:D8,0))
I fear that it would take quite a while to iron out all the parts that need correcting in your code. the code inserts the same column each time its...
Still no .xlsm file
Try this, outputs the detail to column M & N Sub RepeatDown() Dim R As Range Dim C As Range Dim Product As String Dim NextRow As Intege...
The attached is a .xlsx file so cant contain a macro, can you uplolad the .xlsm version?
There is no code in the attached workbook to review? This is limited, but should start you off, the easist way to remove blank rows is to sort the ...
Probably not what you are after, but..... I used the offset function to get the next column, but it does need a number to offset by. I couldnt get ...
can you upload an example worksheet so we dont have to try and recreate the data