Registration date
August 31, 2010
Last seen
June 20, 2016
Contributions
122

How to convert Date of Birth to word in Excel

Dear sir, I have placed my date of birth 25/04/1977 in one cell in excel and I need the result as "Twenty fifth April Nineteen Seventy Seven "as in another cell. Kindly give me the codings for the same. Thanks & regards, Justin Davis

Date and If function

Hello, Thank you for your time! I want excel to determine the date on multiple conditions. If the given date in A1 is 29-Nov-1980 and one of the conditions is 30-Jun-2016 then the date should result to 29-Nov-2014. Please refer to the table below for more conditions. Date of joining As of this year Condition 1 27-Jun-05 27-J... Read more

conditional Formating question [Solved]

Hi I need help with changing the color of a cell based on the Text values in the cells below it. So say B1 is the cell i want to change. B2-B7 has text values 'Yes', 'No', 'In Progress' I want to set this up so if 4 out of 6 has 'No' B1 changes to a red color and vice versa if 'Yes' It changes to green. Can someone help me with this?

How do you make a VBA function in removing a specific value in a

How do you make a VBA function in removing a specific value in a cell. Example: remove "#, " and ", #" #, 1, 2, 3 1, 2, #, 3 1, 2, 3, # Results: 1, 2, 3 1, 2, 3 1, 2, 3 I really dont want to use the simple find and replace since my worksheet is big.. i need your help.. thank you in advance.. Read more

IF formula with dates [Solved]

Hi, I would like to set an IF formula which flags me if someone has been working with us as temp for more than 12 weeks... so I have start date and end date, how do I set the range to obtain this information please? Many thanks in advance

EXCEL, If column terms match text In range b equal to or less th

Ive been racking my brain, the attached photo illustrates roughly what Im trying to do, top and bottom images illustrates a collection if 12k pictures I need to associated the id depicted in the middle portion of the attached image.... what I have ... i know im going the wrong way and my job is kinda depending on this... lol HELP! I know ... Read more

A1 draws amount from other cells by live date.

I'm stumped. I need the value in cell A1 to change automatically the first of each month. Column A2:A13 has dates for the first day of Jan through Dec. Column B2:B13 has hard different numbers for monetary values that change each month (the amount of interest to charge). I need for cell A1 to automatically draw the hard numbers in B t... Read more

multiple options for if in a drop down menu

hello, i trying to make a drop down list in which u can select food and it has a price so in the drop down list there is a3,a4 AND a5(in the drop down list its chicken, corn and bread) and i want to assign the values as a3 TO b3, a4 TO b4 AND a5 TO b5 using the if command/formula. also im using excel 2007 and in another system 2010,wil... Read more

Excel Query

Hi I looking for a formula that will calculate an average order spend by day without having to do this manually(1, 2, 3 ). So for example it takes the running total £10,000 and averages against how many days of the month (say day 10) have passed. So answer would be £1000. Please help!

OVERFLOW ERROR

Hello, I USED THIS MACRO BUT AN OVERFLOW ERROR MESSAGE APPEARS. KINDLY, HOW CAN I SOLVE THIS PROBLEM ? Configuration: Windows 7 / Chrome 47.0.2526.106

What macro?

I want to build intelligent excel [Solved]

Task is: For example I have list of different fruits in cells in separate rows Apple Pear Plum I want the data to be copied to third cell, if second has x in it example: Apple Pear Plum I put x next to Apple Apple x Pear Plum Then Apple will be copied to third column as Apple x Apple Pear Plum Thank... Read more

specific price depending on the words in 2 cells? please help [Solved]

Hello, I am using excel 2008 for Mac, i need help with the following: example: A1 has a drop down box of 3 choices, apples, pears and peaches A2 has a drop down box of 3 choices, .5kg, 1kg and 5 kgs how do i make the relevant price appear in A3 depending on the combination chosen? Thanking you in advance. Read more

make in to single row in exce;

Hello, I HAVE EXCEL DATA IN THE BELOW FORMAT 93456787 BR129 11-10-2011 12:34:00 PM 93456787 BR140 16-9-2012 11:24:00 PM 93456787 BR150 6-7-2014 12:34:00 PM 93456787 BR158 11-6-2015 12:34:00 PM i want out put like in excel 93456787 BR129 11-10-2011 12:34:00 PM BR140 16-9-2012 11:24:00 PM BR150 6-7-2014 12:34:... Read more

Sum values from one column if another column equals x [Solved]

Hello, Is there a formula that can calculate the sum of cells from one column if the value in another specific cell equals x (or not blank)? I tried =SUMIF(A:A,"x",B:B) but that didn't do it. For example: column A 5 10 5 column B x x The sum should be 10. Thanks! Configuration: Windows 7 / Mozilla 11.0 Read more

Subtotal

Hello, Im using subtotal and it isn't changing when i hide values. =SUBTOTAL(109,A42:GA42) Configuration: Windows 7 / Chrome 46.0.2490.86

Tell excel where to look [Solved]

Hello, I am trying to make a cell return a word when you tell it which cell to look in for that word. If i type J2 in a box i want a cell to then look in J2 and return the value, so say november is in J2 thats what i want this cell to show. Configuration: Windows 7 / Chrome 46.0.2490.86 Read more

greater than and less than

Hello, i need help. A4 is the input i need to make it so that if A4 is greater than 1 and less than 100 it will display "centimeters" . Any suggestions?? Configuration: Windows / Chrome 45.0.2454.101

Please Help Create Sub Sheet w/Master Sheet using VBA/MACRO

Hi, I have a master spreadsheet that I want to pull certain information from without losing the format and formulas. I need it to link with my master sheet, so if I update anything on my master sheet it will update in the submaster sheet. I have some basic knowledge in Excel and I read a few of the other threads for ideas but I am st... Read more