Search results

HUI, Thanks man, once again. Two poits however, sumif, takes 3 inputs, but your 1st formula has only 2 inputs. Secondly, why didn't my formula worked??? Would appreciate if you cld reply when convenient. Thanks

Hie forum, Have a column containing numbers and errors. I want to sum the column with sumif function, but it is not yielding correct result. The formula I am using is-: SUMIF(A3:a100,not(#N/A),a3:a100) Am i doing something wrong???

Thanks a lot guys!!

Luke, I have some hundreds of the document numbers and what I am looking for is , if there is a way I can sum all the different documents without having to manually or piecemeal summing them using filters. Thanks Nitin

if Col E contains only hourly and salary, then the following should be fine-: =if(e2="hourly",f2*52/12,f2*26/12) Nitin

Hie forum, I have a sheet wid vendors name and excise duty @ 10.3% against dere name. I have andr sheet wid document no. as one col and the ED broken down into its constituen part, i.e. 10, 2 and 1%. Since there is no common data linking the sheets, I was thinking of trying to sum the second...

HI forum, Is there a way to use countif for comparison purposes as explained in chandoo's post of comparison ninza, where the two columns contain amounts but with minor changes due to rounding off. eg one column contains 819 and other column contains 819.6. Thanks Niting

Hie forum, I have some date coming from SAP in this format-: Col A COl B COl C 01-04-2010 Narration 4444 03-04-2010 Narration 5555 05-05-2010 Narration -4444 Now the point is that the positive entry will be knocked off by the negative entry. But the entries happen at different dates...

Hi forum, I have a sheet with colA with job codes and COlB with vendor name. Other information are in other columns , specifically , like amount in ColL. The entry for one particular vendor against one particular job code appears many number of times in the sheet. Now, in other sheet, i wish...

Hui, What is the YearFrac formula achieving in the 1st reply to this post??? Thanks Niting

Hi forum, I used a formula in cell F2 like IFERROR((SEARCH(F$1,$A3)>0)*$D3,""). Now copying it across from col F till Col AZ is not a issue. However, i have to copy the formula down till row no 300. Do i have to copy the formula down individually for all columns for col F till Col AZ. or...

Thanks Hui, Worked!!!

Hi Forum, I used a formula which was like if((date in $a$3-date in a2)>366, 28,0) and copied it across the range However, even with cells which had to be subtracted, being blank, the formula produced the result, implying it took the blank cells as some date. Could you explain why it is...

Hi forum, I had read sometime bak in the forum, the macro for deleting alternate rows. I tried searching for it, but could not find it. Could u share the Macro and could we also apply the macro for particular ranges instead of the whole sheet??? Thanks Nitin

Luke, Thanks a ton!!! I know there are many ways of solving a same problem, and excuse my over zealousness, but could we have also used Index and Match or any other Lookup tools to solve the same problem??? Thanks again for the prompt reply Nitin

Hey Forum, I have a sheet 1 with 3 columns, COl A with A/c codes, Col B with the month Names, Col C with the values. In sheet2 I have col A with A/c codes and row A1 with Month names and I want to poplulate the Col B with values corrosponding to the month and A/c codes in Col C in the 1st...

Hui, I have to say that u rock!!! More than the solution provided, u had an idea what problem i am facing and what question i am asking, This is why u posted an alternative solution. Thanks Hui. Hui, however, when i am using =D1=1 and applying it to the range B1:C26, it only hilits the B...

Hi forum, A small query!! I want to highlit a range of cells, say B1:B26, based on the value being "1" in cells D1:D26. When i apply CF using formula, the result is not coming, i am applying the following to range b1:b26 =countif(d1:d26,"1")>0 But I am not getting the result, could...

Luke M, Thanks for the suggestion. The shortcut refers back to the precedent without evaluating the formula, but I wld want to simultaneoulsy evaluate the formula in the active cell and move beetween the cells referred to in the formula, without having to scroll manually through the...

HI Forum, I have immensely benefited from the Post"Comparison ninja" at Chandoo's However,if i have a list which i want to compare against 4 other lists simultaneously, do i apply the CF sequentially and clear the formatting or is there a better way?? Thanks Nitin

Hui, sorry fr the delayed reply. As for the problem, i am facing, as you wld notice the data is in sheet 1 month wise and according to units. In the VC_Components sheet, my columns are component wise and the months are in rows. The problem that i face is that i insert a formula in month of...

Further, as you would notice for sheet 1 and VC components, the data which i m using in formula in VC components is in columns of Sheet 1, but my work range is in rows in , so i have to manually edit the formula for each component, Is there a way to copy the formula across the row???

Hey Luke & Hui, The link to the sheet is http://rapidshare.com/files/442003054/Copy_of_aNALYSIS.xls I have to compile data based on sheeet WCA in VC_2 and there I face the problem of not able to copy across the formula and retyping the formula. Appreciate the help. Thanks Nitin

Hi Forum, I have some data in sheet 1 in cells A31:AA40. The same data is repeated for another month in cell E31:E40. I work with this data in sheet 2. Now, the months are consecutive in sheet 2 and because of this I can't copy the formula used in col A to Col B in sheet 2. Could you...

Hey, Teh formula does not seem to work. Could you suggest an alternative?? Thanks