Search results

Thank you very much ,Deepak and Misra. Deepak , Invoiced amount is matching perfectly , but the payment received shows the same month of invoiced amount , it should be 1 month later of invoiced amount. Misra , your formula worked perfectly , thank you very much it saved my lot of time . Once...

Dear All, I am looking for a lookup and match formula, In sheet 1, I want a formula for invoiced amount and payment received month wise , where the data is in sheet 2 as per the attachment . Not getting how to proceed with the formula , tried Vlook didn't succeed.

Dear Narayank , Really it is Gem :) . it worked perfectly . Thank you very much for your help. It makes my 2-3 hours job into 10min work.

Dear Chippy , I think there is a misunderstanding in the result i required. sorry , i think i didn't mention proper . I require the whole number like 0.60x1.00 not 0.60 and 1.00 separately. Please find attached the file , where i mentioned the numbers in Bold . Thank you very much for your...

hi old chippy , It worked very well , thank you very much what about if its text or like below in a range. 0.60x1.00 0.3X3.15 0.55x1.00 0.60x1.00 0.70x0.70 0.75x0.85 0.75x1.00 0.75x1.10 0.75x2.15 0.75x2.25 0.75x2.65 0.875x0.55 0.90x1.10 1.00x0.55 1.00x0.650 1.00x0.75

Dear Balli, Even if 2 or more numbers are in a row, i need all the numbers in a column only .

In a sheet range a1:x25 , i have a set of 30nos staggered in the range and some of the cells are empty. The result i want from A30 in column wise all the numbers in a range.

Jai , Thank you very much , it worked perfectly. I was trying only with VLOOKUP Function. It saved my lot of time . Once again Thank you very much .

Dear all, In sheet1, I have 2 columns date and currency ( USD, EUR, GBP , YEN) , in Sheet 2 I have 5 columns ( Date , USD, EUR, GGBP,YEN ) as mentioned Below I need formula in Sheet 1 that matches date and currency wrt to sheet 2 , I am using formula...

https://skydrive.live.com/redir?resid=BD6F0FD0626C9C31!178&authkey=!AIGCm1hnE7mj1Wk A shorter link : http://sdrv.ms/URYLUk

Dear All , Find below the Link i require formula to complete the project on following 2 options. i) Nos of month required based on current progress ii) If the project has to complete within Aug-13 what should be the productivity every month. Please find below the link for the file ...

Dear Kaushik03, Thanks for your help and guidance regarding the 1900 and 1904 date system, I didn't knew it till i face this problem I had gone through the Link you had send it, it helper a lot. I am working on Excel has MacXL default 1904 date system , where as the data i am copied from...

When i copy the dates from one file to another the year changes , even i f copy and paste special also the it changes. Any particlar reason?

Dear Hui, Thank you very much it worked perfectly. This formula i am using for currency fluctation , Client is agreed to pay 1 usd = INR45 and maximum of INR46 more than 46 has to bear by contractor and less than 45 the contract has to forward the benefit to employer. if its between 45 & 46...

Dear All, I am not getting proper answer , what i required please do the needful A B C D E F G H sL qty rate min max rate-a 2 500 57.5 57 58 57.5 3 1256 46.02 45 46.5 46.02 4 452 44.44 45...

Dear Faseeh, It worked perfectly, thanks for your help. Can you explain why we have to mention "COLUMN"

Dear Luke the values are in sheet2 a b c d e f g h 1 No 2 2 0.541 0.459 3 3 0.292 0.479 0.229 4 4 0.188 0.353 0.316 0.143 5 5 0.136 0.252 0.298 0.212 0.102 6 6 0.106...

Dear All, I have 2 Sheets where in sheet-2 my co-efficient are calculated , i need a formula in Sheet -1 with respect to the Nos For Example in C2 if i mention 2 then corresponding to sheet 2 wrt 2 i need 0.541 and 0.459 in "D" and "E" column same way if i mention 4 i should get values in...

Dear Faseeh, Thank you very much it worked perfectly . It saved my lot of time.

Dear All, I need a formula D E F G H I 23 2 1 11.00 0 0 In I i needa formula if ( G23=0, h23=0, result is Product(d23:f23) and IF(F23=0,D23*E23,IF(G23=0,ROUND(D23*E23*F23*H23,2),IF(H23=0,ROUND(D23*E23*F23*G23,2),ROUND(D23*E23*F23*G23*H23,2)))) Please do...

Hi Hui, Thank you very much, I was scratching my head from past 3-4 weeks for the increment value of 0.1.Thank you very much once again.

How to Format "Form Controls" from Developer menu, with a incremental value of 0.01 . Whether i can insert 3-4 Form controls in a sheet

Item# Desc Qty TT Custom Manufacturing, LLC TOTAL HF Collections TOTAL PF-1201 SOFA 1 $875.16 $875.16 $2,528.00 $2,528.00 There are around 15 supplier are there to compare the lowest rate and vendor name i am using to find the minimum value : SMALL(D5:AG5,IF(MIN(D5:AG5)=0,2,1)) To fine...

Dear Hui, I tried but it was not working, I don't know where i have done wrong can i forward the file to you? Plase share your email id . Thanks

Dear Hui, I want to highlight minimum of each row from D6,H6,L6,P6,T6 , The range is around 700 rows, insted of formatting each row, i want to format till the required range.