Search results

Thanks Hui Sir, But I am asking how can I setup this form in excel, and I dont want any link with this excel I will just fill the form and take print out instead of writing. Please check attached sample. Regards, pAvi

Dear All, I am manually writing 20 to 25 attached form on daily basis. I want to make excel format where I can type and print on origional form. Regards, pAvi

Dear Zameer, Is your file related to Amit's query? Please check. Regards, pAvi

Awsome solution Narayan....

Dear thifu3, Please check attached file. Regards, pAvi

Hi Barneybeardsall, Please check this. Regards, pAvi

Dear TG3, You can use advance filter to get the require output.

Hi Sameer69, May be this chart will help you. Thanks to Faseeh for this chart.

Hi All, Can any1 help me to make attached chart. Thanks & Regards, pavi

Dear Ajay, Please upload your final template where you want updated data. Regards, pavi

Dear Ajay, Hope this will work. Regards, Pavi

Thank you Thank you...

Hi Lohith, Please help... I want below code show 2 decimal place always please help. it's not working when there is 10,20,30 and so on till 90. Select Case Pounds Case "" Pounds = "" Case "One" Pounds = "" Case Else Pounds = Pounds & "" End Select Select Case Pence Case "" Pence...

Hi All, I change the below code but not get what I want... please help I want number in word with decimal in below code decimal not showing. what I want is 1000.20 "One Thousand and 20/100 Only" I want 00/100 only if there is 1000.00 Please help Option Explicit 'Main Function...

Thanks Lohith... its working

Hi All, I change the below code but not get what I want... please help I want number in word with decimal in below code decimal not showing. what I want is 1000.20 "One Thousand and 20/100 Only" Option Explicit 'Main Function Function SpellNumber(ByVal MyNumber) Dim Pounds, Pence...

Assalamualaikum Faseeh bhai Ramadhan Kareem to you and your family. Dua me yaad rakhna. Regards, Pavi

Astonishing work Deb... Regards, Pavi

Nice workout Deb... :) Regards, Pavi

Hi GGGGG, You can use Code formula to the invisible Characters. Regards, Pavi

Hi All, Below formula working. =OFFSET($AL$3,MATCH($B4,Tar_Reg,0),MATCH($C4,Tar_Pro,0))*LOOKUP($C$1,Target) Regards, Pavi

Hi All, Please help on below formula. =OFFSET(AL3,MATCH(B4,Tar_Reg,0),MATCH(C4,Tar_Pro,0))*LOOKUP(MATCH(C1,Tar_Mon,0),Target) I am getting result for below part =OFFSET(AL3,MATCH(B4,Tar_Reg,0),MATCH(C4,Tar_Pro,0)) I want to multiply the above result to Target Range C1 is date(mmm-yyyy...

Thanks Mahaveer formula working fine. Regards, Pavi

Hi Narayan, Below formula working but I want same like vlookup if that no. not begining with 300000 then it should be blank or zero and below formula giving sorted value. =INDEX(Data_Range,SMALL(IF(ISNUMBER(FIND(30000,VALUE(Data_Range))),ROW(Data_Range)-MIN(ROW(Data_Range))+1),ROW(A2)))...

Hi Jason/Mahaveer, I have below data in column A and I want formula to get value started with 300000 and for others blank or zero. 20 21 22 23 24 25 26 27 28 29 30 32 4954100 4954200 4954300 4954400 30000001 30000001 30000004 30000029 30000034 30000036 30000036 30000037...