Search results

Hi, Need help to to get the formula for my alphabet code to number as per below example. A to J represent the number if I type the code JFGAA I need 15400 as output A 0 JFGAA 15400 B 9 JIAA 1200...

Hi, Help to modify the formula Based on the Item number need to find matching debit credit one on one value. The formula solution provided by Mr. Bosco is attached. Regards, PaVi

Hi All, Need the formula to find the matching amount in debit credit or netting based on Item Number. Thanks in advance for your support and help. Regards, PaVi

Hi, Need the formula to distribute backlog value year-wise as per the end date. I really appreciate any help you can provide. Sample file attached. Regards, PaVi

Hi, I have two sheet in one sheet I have Total CTC for each employe in other sheet Jobwise number of hour each employee work in particular job, So I want to distribute the total CTC amount to each job. Sample fine attached with required output. Thanks in advance. Regards, Pavi

Hi, Please help I am using Excel 2019 and using AutoFormat for Pivot table when i am converting pivot using paste special Value pivot is loosing its formatting. Thanks, Parvez

Hi, Please help me to solve the formula for my dashboard. I have spreadsheet where I will update the price daily I want current value column U should calculate the last updated price. Sample file attached. Thanks, pAvi

Hi, Need formula help to fill the date from the begin of page as per sample file. Regards, pAvi

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

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

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

Hi, I want to repeat Range C339:J343 in footer. Please help. 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...

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

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

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

Hi Ninja's, Please help me to get the desire output. 6% 7.0% 9% Jan-14 Feb-14 Mar-14 Q1 I want to divide 100 in 3 month as per % in row1. Thanks for your help. Regards, pAvi

Hi All, Please help. I want to create worksheet with name list. I have 50 name and I want to create sheet with each name. Regards, pAvi

Dear Ninja's I have data AM2:AO78 and I want formula in AG3 sum of all customer for model1. Please check uploaded file. Regards, pAvi

Dear All, I have a data D2:AF42 with conditional formatting (Data bar, Gradient fill) but in row 14 to 35 showing different type of formatting. Please help. Regards, pAvi

Dear All, Please suggest how to present attached report to Sales GM for Analysis. 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

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

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...