I am using this VLOOKUP formula to remove blanks: =IF(VLOOKUP(I8,Vendor,2,FALSE)="","",VLOOKUP(I8,Vendor,2,FALSE)) When it finds a match, it works fine, when...

Evening everyone I am sure this is simple but it's late and I'm very tired. I have the following IF statment but I need all three to be added together - the...

Sir, How to count total point for cell A1 to J1: A B C D E F G I J 1 4 1 4 3 ...

Dear Sir, I want to calculate formula which refers 3 cells out of 4 cells. for eample a1=5, a2=2, a3=9, a4=16. i can able enter all the 4 cells, if i enter...

I have a drop down list with names in it. I need the names to disappear as they are being selected when you go down to the next row, so when you get to the...

Hi, I am trying to set up a timesheet whereby I can put in the start time and end time of the job and get it to calculate the amount of time spent on the...

I would like to be able to hide a number of rows based on the response to a question.. The response to the question is a list box with either "yes" or "no"...

hi i have a sheet that contains a column with dates from jan to dec which i have also formated as a table. i have a sheet also formatted as tables...

Hi, I had a huge file of aroiund 10 000 line. This 10 000 line only consist of 500 items. I wish to have an analyise a information. Example in the file it...

hi all! i am having thousands of names in col A the problem is the initials are before the names..! for example as A.K.PRAVEEN C.GUPTA

hi all! i am having names in COL -A all begining with intials followed by the name and some names without initials as...

See this formula, the function is not working in the spreadsheet. Another alternative would be to insert a max function - how do I do...

A lot depends on how you have that second sheet set up. To work, first the names on the two sheets must match up exactly with regards to spelling and...

I have following code: Sub climate() Dim x As Long, y As Long x = Range("X" & Rows.Count).End(xlUp).Row y = InputBox("enter the row number to...

I used the pivot table and it worked like a charm. However, the data is going to be transferred into another program and it needs to be in the same format as...

I am attempting to use the list function within data verification for drop down menus. I need a list that is conditional upon the information in another...

I have rows of data divided into counties with tonnage amounts in a cooresponding cell. I need to have one row for each county, and the tonnage for each...

When adding a column of numbers, the sum function failed to accurately sum the numbers. Even summing just 1200, 800, 700, 700 yielded 1900. How do I...

Cell Range A1:A35 are different colours (Red, Green, Blue - depending on their value) I want B1:B35 to show a number, based on the colour of...

Dear expert, I want to create a workbook with different worksheets for different users. For security purpose, I want different worksheet has a different...