Search results

And your final output would be one workbook with two worksheets, one for type 1 and the other for type 2? If yes, will each sheet have data for each client coming one below the other? to make the assumptions clear, would you be able to post a few samples of input and output?

And all of these are in one folder you say..?

Brian, does these workbooks follow any name pattern? How would you distinguish each client workbook, and each types per client?

Great... for posterity, it would be nice if you can post the solution too, Jovica.

Another example http://office.microsoft.com/en-in/excel-help/customize-how-excel-starts-HP005199391.aspx

Don't understand exactly what you are looking for, but one of the lines in your sheet mentioned it only needed the Prj. Amount and the Value... so not sure what is required of the phases. Have a look at the file I've attached though.

Did you not look at this? http://office.microsoft.com/en-in/excel-help/save-cell-styles-to-use-in-all-new-workbooks-HP001216733.aspx

Just got this on search... http://office.microsoft.com/en-in/excel-help/save-cell-styles-to-use-in-all-new-workbooks-HP001216733.aspx

You can actually ignore the 'To' column. Assuming your 'From' and 'Percentage' data are in columns C and A, starting from first row, use this =INDEX($C$1:$C$7,MATCH(YourLookUpValue,$A$1:$A$7,1))

Oops... sorry Narayan, I had the window open for a while and didn't realize you had posted.

So what would be your output in this specific example? Just to understand your requirement...

Well, in that case, it's the VBA route, though I'd be more than happy to stand corrected.

Good day to you too bobhc No argument. Completely agree :)

Oh, OK Luke :), sorry for jumping the gun then. I was just trying to conform to Xiq's question about generating an array {1;3;1;3......} By the way, I did save you the parenthesis nonetheless ;)

Luke, you probably meant ISEVEN(ROW(1:12))*2+1 to get that array

Here's another so-called 'dirty' way, non-dynamic 3^MOD(ROW(2:14),2)

Not unless you use VBA, or, if the original cell is using a conditional format, use that same conditional format in the cell where you're using the VLOOKUP function.

OK. In that case, your thread title is misleading. I think a more appropriate thread title would have been "Extract Numbers From Text". Wouldn't you agree? :)

Yes, you got all the numbers together. So is that what you wanted?

Abhijeet, based on what Kris has written, it is imperative that the code is run from a code module, and not from a sheet / workbook code module. I've used Kris's code here (just changed the 2 minutes to 2 seconds cause I get bored easily ;))

What should the output look like?

Why do you want it to happen when you 'filter' something? Why not have a button, which when clicked, changes all values in Col F, where Col D = "C", to turn to that text ?

For such charts, I'm afraid you'll have to use some alternatives like that. One another way is to equate the data-label value to a fixed cell. In that case, any value in that cell will be shown in the data-label. The other way is to use a Change event macro.

Not sure what you meant. You mean you want the code posted here? If yes, here you go Dim blnUnlockedAllCells As Boolean Private Sub Worksheet_Change(ByVal Target As Range) Const RangeToLock As String = "A2:D1000" '<< adjust to suit If Target.Cells.Count > 1 Then Exit Sub...

Just right-click on the cell and format it with the text as you want. The actual value of the cell will be some number. But the format will be the text you want to display.