Hi, I have a worksheet that is Plan calculator for customer of a telecom company. There are four sheets, sheet 1 Instructions (Instructions given how to put...

Dear All, I am new to excel and not good with formulas, my problem is i am trying to make a daily and monthly reporting format, but a little problem i am...

hi, spellnumber fuction in excel is for getting figures in text in english ie. 100000.00 formula converts it in its text "One Hundred Thousand Dollars but...

Hi to all good people, I am workin on an excel sheet in which I have to make Maping of Payment received and mode of payment is Cheque and Cash. I am in...

Hi Good People, I am working in excel worksheet for a payment collection activity and in culumn Ato Column Z i have detail of customer and in column AB i have...

Hi, a1,a3,a5.......... =a1+a3+a5............. can i use a formula that calculate every next row. Thanks in advance, Aarif

Dear all, I am an average user, facing problems in using formulas becouse i do not know that how which formula should be used for such function and how to...

Dear all, I do have a file containing cheques value as by encoded it shows figures in dollers & sents without decimal points. I want to convert it to value...

i want an if then statement. i have it now so that something happens if x = y. well, i want the same thing to happen if x = y plus or minus 1. i found...

Hi, I am hoping someone could point me int he right direction on a problem I have. I have a series of conditions that give me a range of cells say a1 to a10...

Hi Everyone, I have thousands of cells with names and addresses, and each cell combines both. I'd like to separate "Jane Doe 123 Street Road" into "Jane Doe"...

=SUM(IF(Sheet1!$K$5:$K$705=A12,IF(Sheet1!$M$5:$M$705=1,"PSP*"))) I'm trying to get a number value on Sheet 2 for how many times a cell starts with PSP but...

Hi, I had this formula that works...

Hi, Is it possible to make excel spreadsheet automatically snap to cells or jump around the spreadsheet when enter (return key) is pressed rather than just...

Hi, I would like to run a macro that asks the user of a worksheet a few questions and gathers the information from them before they start working on the...

Hi, Trevor Shuttleworth kindly wrote this formula for me: A1=300 A2=g 300 This weight 300 is in g 300.1 This weight 300.1 is in g 300.12 This...

I have a spreadsheet which contains a summary sheet and then a number of detailed worksheets behind that. Is it possible when entering details onto the...

Hi Bit of a strange one this, I have a vlookup formula that returns long text strings. I'd like to have the cells wrap the text when necessary, however...

I would like to create a formula to take todays date and subtract a birthdate. K2 being the cell with the date "b-day" in it, such as { =today()-K2 } to...

My Question is how do I create a worksheet that contains only rows that contain a certain name on a different worksheet. I have an exported list of data that...