Search results

Hello friends, i am in a fix please help me with my problem. i have uploaded a file on my box account Link: https://app.box.com/s/b2af1fqy1m2dua2vgw3o Scenario: There are two sheets, Sheet A and Sheet B In sheet A I have highlighted three columns Column D, H & Q. Columne D has a date...

I have an excel files with huge amount of data. I need to select data of alternate columns. can anybody please help with this.

@ faseeh: it did give me correct result for the first case. but not for subsequent ones. Another manual testing is done for 2nd case and is updated please do have a look https://docs.google.com/spreadsheet/ccc?key=0AgDJ-TLtQDaydFhJTnl2UF9LU0NpeGJiNTMtbGpzUWc @ SirJB7: Problem still...

Dear SirJB7, The sample sheet is fixed and saved.. kindly have a look.. Thanks upfront!!

Oh damn me.. another mistake in the sample sheet... It should had been 266000 to 267000, 267000 to 268000 and so on.. my bad.. may be the pressure is making me do such blunders.. i apologies.. hope my repeated mistakes wont make you lose interest in the topic.. looking forward for the...

@ SirJB7, No sir in the whole range F27:G218 only the following are falling between interval 266000 and 267000 1. Sr. No: 1 from 266000 to 270000 2. Sr. No: 2 from 266530 to 271000, and 3. Sr. No: 5 from 266420 to 266420. rest all are either a value equal to/before 266000 or equal...

Hello SirJB7, the formula is not giving me the correct answers. the uploaded sheet has been modified as per your suggestion.Some mistakes have been corrected too.. I understand that it is always better to keep it simple. Amendments are made and saved.. looking forward for a solution. Thanks...

or do you think i should export all data to MS access to have a better control over the data...

Thnx sirJB7, that solved the circular reference error mystery. As of the data in Column H. it is not the actual problem is it is a formula to exactly locate the overlapping data suggested by Hui Sir http://chandoo.org/wp/2012/01/17/formula-forensics-no-009-2/. I actually forgot to do the CSE...

I know the sumproduct should do the trick for me. But i am stuck when it comes to 'step 5 ' not able to formulate that...

The above references are of file https://docs.google.com/spreadsheet/ccc?key=0AgDJ-TLtQDaydGoyUEdtLWlGZ2RlNXRtYWYxYjJMMUE

Hi Faseeh, Thnx for the post... I think i did not make my question clear to you... Yes the index function in column F you suggested is sure giving me results.. But my requirement is to get data in column L Which is the sum of all those results derived from index function for each frequency...

Hello SirJB7, a screenshot of the error message is here http://i50.tinypic.com/2sb93ls.jpg Although my main question still remains unanswered. A fresh sample sheet with elaboration of my problem is here...

Dear Faseeh, Thnx for ur time and efforts . But the formula did not help me. The results were still treated as texts making the same non-responsive against mathematical function being performed on them. However Hui Sir's formula did gave me the perfect results i desired. as for elaboration...

Please help me with this.. i have got a dead line... Google doc format: https://docs.google.com/spreadsheet/ccc?key=0AgDJ-TLtQDaydDZYRzVjdDNLRW5BWlBJbk1nTjg1NVE

Please help me solve these... the problem i am experiencing is described in detail in the sheet... https://docs.google.com/open?id=0BwDJ-TLtQDayMGJWV2JrNXA5QWs

Thnx hui.. works perfect for me...

Hi hui.. its a relief to find you at this tym... the formula aint working for me coz for the first series it is giving me the right answer 48.2725 but for the second series instead of 58.36 it is giving me 48.2725 + 58.36 = 106.6275 Please help solve this...

Plz help.. Sample sheet attached... https://docs.google.com/spreadsheet/ccc?key=0AgDJ-TLtQDaydHpDWjFLZFZIWFF6MVM1b2VaLUxHZWc

Thnks luke the first formula with a little tweak worked for me. Thank a lot...

https://docs.google.com/spreadsheet/ccc?key=0AgDJ-TLtQDaydGQ0X1hjSGwxcEpEWHFfQUJacktralE

Not working.. it is giving me the same last column value for every range. iam uploading the excel sheet. plz help me with it..

To simplify my problem I wish to return the last value just before the next blank value in the column.

@ luke, The formula is not working. since it is taking the whole column A as the array it is only returning the first value of the range.