Search results

TRYING TO EXPLAIN THE FORMULA =INDEX("ENTIRE RANGE",1,MATCH(INDEX("ENTIRE RANGE",MATCH("P23","CABLE RANGE",0)+1,MATCH("DP1","Data Pipe Range",0)+1)-1),"RANGE OF P23",0)

OK, I have worked it out. As I am in my office, I dont have access to Shared website, so cant upload the excel file here. Please share your email id here so that I can send you the file & you can upload the same here. Formula what I have used is below entered in B13 against P23 & I know it...

Adding - 4 in that line works perfectly. I cant understand the logic behind this, but it works. Great ! Thanks once again.

Sorry to bother you again HUI. The code given by you works perfectly if my data has 4 columns, but if I add 5th column & change rngreviews range, for 5th COlumn it again starts with 1. I almost spent an hour doing R&D as I thought I would be able to crack why this happens but in vain. My...

Thank you so much for your support & guidance, HUI. The above code works perfectly. Just made a little change in the last line have added - 1 after Numb.

This code works smoothly.

4 C D E 5 1 10 19 6 2 11 20 7 3 12 21 8 4 13 22 9 5 14 23 10 6 15 24 11 7 16 25 12 8 17 26 13 9 18 27 . . 28 (Value to be updated here i.e E28) As...

Please go through first 4 websites. http://lmgtfy.com/?q=what+is+excel+correlation

Thanks a ton for your reply, Hui. I had tried changing the range i.e rngReviews but in vain. The difference/problem in chandoo's code is irrespective of what you select C5 or D5 or E5 it will update cell value as 1 in E28.(If you can please have a look at the excel attached in chandoo's...

I have NIL knowledge regarding VBA. Require help for below. http://chandoo.org/wp/2011/04/07/show-details-on-demand-in-excel/ After reading above post of Chandoo, I am trying to modify the below Selection macro code. In chandoo's sample excelsheet given in above link, when you select on...

After changing dates to text i.e jan to 01/01/2011 you can also use below simple formula =IF(AND(MONTH(D$1)>=MONTH($B2),MONTH(D$1)<=MONTH($C2)),1,0)

Hi, All the Columns have the same Header names in all the sheets. Select Data - Pivot Table/Pivot Chart (For Excel 2007 press Alt + D + P) In Pivot Table wizard window - Select Multiple Consolidation Ranges - Next Select First Option - Create a single page field for me. Now In Range -...

HUI meant to ask is there any Macro in the worksheet which converts all the Cell to date format upon opening. I have heard similar problems faced by my colleagues in Excel 2007. Below are some solution might be they help. (Excel 2007) Select the entire workbook - (Ctrl + A - 2-3 times) Go...

I believe you are using Excel 2007. ( This might work in Excel 2010 also) Click on the cell where you need to apply conditional formatting. (Doesn't matters if any particular country is selected in filter.) In Home Tab, click on Conditional Formatting - New Rule. In the New Formatting Rule...