give

If I have a sequence of numbers running vertically in column A, e.g 1901 1902 1903...up to 1952 If I have a number in cell G3 that is not found in my list, eg 1953, I want the function to then give me the number provided in G4 instead I know i'll want an IF function but cant figure it out...

I need so assistance with a formula. I am trying to use and if statement to determine a amount. I have a column that has a value of 1,2,or 3. If the value is 3 I need to take the amount in another column and multiply it by -1. Also if the value is 1 but the amount is already a negative...

I'm looking for a reverse formula that will give me back the number of the beginning meaning : 0212010 would give me back 2436 ? in cell : R8 Q8 =IF($I8="","",INT(LEFT(MOD(SUM($H8/1),4)))) P8 =IF($I8="","",INT(LEFT(MOD(SUM($H8/4),4)))) O8 =IF($I8="","",INT(LEFT(MOD(SUM($H8/16),4))))...

Hi there, I need a code with the INDIRECT Function that will allow me to delete rows and the function won't give me that #REF alert. Cell A1 is 0 Cell A2, =IF(B2=B1, A1, A1+1) Cell A3, =IF(B3=B2, A2, A2+1) So on and so forth... About 400 rows... I'm "categorizing" the unique values. If it...

Hi, hopefully I'm able to explain my requirements easily enough here. I'm trying to create what I think should be a simple pie/doughnut chart however I cannot quite get what I want from it. I'd like to show a pie chart but then overlaying equally sized lines to give the appearance of various...

Hi Team. I need a VBA code to transpose.column data into rows. Below is example. Sheet 2 Column A Column B Sl no. Data 17957 Missing number 17957 Missing Data 17957 Additional data required 17957 Address not...

Hello All, GetPivotdata formula will give column values from a Pivot. Is there any formula similar to it which will give row label data from a Pivot?

The issue that I am having is, is that I have names in one column and the team they belong to in another. I would like to auto populate the team the name belongs to. However, the way the names and teams are broken down I don't know how to make it work out. I have provided an example that would...

Good Morning, I have this formula to give me the percentage completed by count of project =COUNTA(L5:L10)/COUNTA(B5:B10) but what i need is that if in L5:10 have the words "Completed to give me the percentage only when the words completed are in the cell and not to count any other words in the cell

Hi all,,, Please could you help me with this. When I start to type a name in a cell, I type the first letter and it shows the rest of the name, for example If I type J J it will give the rest as J Jones, but if I carry on and type the rest e,g, J Ja it does not give me Jackson as the rest, can I...

Good evening, I have spreadsheets that I receive from clients which have times in different cells. I have a 8:50 in cell A1 and 3:10 in cell B1 when I looked closer the cell values both have AM in them. I looked at the next one and it also has 7:15 and 4:10 and they are also AM. The times will...

Hi. This is quite simple but i just don't know how to get around it. The formula C+(A*B)-D C is essential in computation but often empty. this give me a value error if C is empty. What should be the right formula, not to get value error? Thanks

I would like to make a formula stating below: worker finishes work at 18:00, after 18:25, we give half an hour OT after 18:45, we give 1 hour OT I also need to take into account some workers might work a few hours OT, therefore if he finishes work 19:25, I need excel to show 1hr30minutes OT...

Hi I want to create an excel file which will be shared by different users. This file has several sheets called user1, user2, user3, etc can I give each sheet a different password, so the user associated with that sheet can only open his/her? thank you very much.

Hi friends i have this numbers: 5,6,7,8,9,10 wich is the combinations of these numbers that give me an average of 9, (the numbers can repeated) sample: 9+9+9+9+9= 45 / 5 = 9 10+10+10+7+8 = 45 / 5 = 9 10+10+9+8+8= 45 / 5 = 9 and with 5 numbers wich combination of numbers that give eman...

Good Morning, I am attempting to get the follwing to work, not much above novice user but I try, not sure this is even possible, working formula and purpose at bottom of post. Couple of failed attempts, based on help on simpler issues and internet searches. =SUM(COUNTIFS($A$10:$A$58...

hi, I have date in A1 like 12/11/2018, dd/mm/yyyy. and B1 have days like 5 days. I Want answer 17/11/2018 in C1. please give me formula

Hi All, I have a sheet where i have a column with mix of Letters & numbers. in another column I want to assign a number to the letter (in this instance it is an "R" & i want to give this a value of 1) & i want to increase the values of the occupied cells by one. So i want to change a 1 to a two...

Hi there, I have an existing macro (thanks MrExcel) and it works perfectly on the first sheet, I now need it to do the same for the other 10 sheets in the workbook. I have spent many a frustrating hour trying to do this with no success, I would appreciate any help anyone can give. Thanks and...

Hi I am looking for assessment questions to assess my level. I did google search but I would like to know if you know good site or you have a sheet that will give me my level after answering questions. I would appreciate your help. Thank you.