Search results

Hi all, I want desire output using vlookup for multiple value in data table. Sample attached. Thanks pAvi

Thanks.

Hi All, Need your help to get required field from Data entry sheet to Output Print. Regards, paVi

Great Sir.... this is what I want. Thank you.

Hi All, I need formula help to get desire output. I have drop down in C3 and have 2 groups A & B if I select from drop down rest of the team name should appear from C6:H6. Please check attached file. Regards, paVi

Thanks Narayan, No it's not urgent dear take your time. Regards, pAvi

Hi Narayan, Please check uploaded file if you can help me. VBA will do no problem for me. Regards, pAvi

Hi Narayan, Yes C309:J313. pAvi

Hi, I want to repeat Range C339:J343 in footer. Please help. Regards, pAvi

Thanks Deb & Well try iferror. Regards, pAvi

Hi All, I have data in A2:A15922 in 3 decimal format and I want last 3 digit after decimal but when number ending with zero Output showing e.g 120 its showing .12 all other showing correct. Note last 3 decimal number is from 001 to 999. Regards, pAvi

Hi All, Need help to correct code convert number to word. e.g. if value is 1202.121 its showing correct but if 1202.120 then last zero not showing in decimal place. Option Explicit 'Main Function Function SpellNumber(ByVal mynumber) Dim Pounds, Pence, Temp Dim DecimalPlace, Count ReDim...

Thanks alot SM for your precious time for my query. This is require for Dashboard and I will adding data every month so may be your solution will slow down my report. But I will learn lot of things from your solution. I will utilise this in other report. I will get back to you if need more...

Congrats SM & Sajan :awesome:

Dear SM, Thanks alot you are genius dear. Thanks again. I have one question if I want only top 5 Label name based on total without product then formula will be small lengthy like your last reply, because I didn't understand the formula it's look very complicated. If I get Label name based on...

Yes SM it will OK with me. Regards, pAvi

Thanks SM/Faseeh, I want my output in Top5 Table (C5:F9) and Bottom5 Table (H5:K9) using formula. @Faseeh, Top/Bottom 5 based on total of TT & PP. Regards, pAvi

Hi Ninja's Please help me. I want formula for top 5 & Bottom 5 name using formula. I have data in RAW sheet and I want formula for View sheet. I put the required value in manually. I have drop down in C2. Regards, pAvi

Thanks Mike and Haseeb both Formula working. Regards, pAvi

Hi Ninja's, I please check uploaded file I want formula for sum of target. I have area and month drop down in J3 & D3 respectively. I put the desire output in cell p10 & p11. Regards, pAvi

Thanks Debraj, I tried my self to correct but fail. Thanks again. pAvi

Dear Debraj, Model 15 is not showing when I select R1 in C2. pAvi

Thanks Deb, Exactly what I want. pAvi

Hi Ninja's I want 1 formula help I have dropdown list in C2 and I have data M3:N38. I colored red my out put in uploaded file. Thanks pAvi

Thanks Hui Sir. Regards, pAvi