Get instant free expert help with Excel and Google Sheets

I want to compare my data with normative values and rank as good fair poor etc. it also has to be aged matched. Can you help me with rank excel function?

I am trying to get rid of any row that contains a 1 in the N column, I can't figure out the formula.

we have two excel sheets that are similar but i need excel to tell me what the differences are between them? i have 2016

Do you have a link or a recommended course that will walk me through the full process on how to use excel?

Hi, I'm trying to get a Data validation formula to work. the cell I will be doing this on is A1 So the Data validation for cell A1 would look something like this: Custom: =IF(A1=0,B1/208,A1) I'm wanting to add a value into cell B1, so if cell A1 is left blank, I can reverse engineer an answer IF cell B1 has a value in it and cell A1 does not. BUT If cell A1 has a value, It will just display that value and ignore the rest of the formula. IF A1 AND B1 are both 0, then both cells will just show 0. I tested this formula on a cell and it works great, It's just not working from Data validation. Maybe because it's referencing itself?

On the vlookup tab, i need the Job Title column to be inserted into the Current Job title. Theres 400 na,mes on the Working sheet and 590 on the vlookup sheet. there should be a discrepancy of 190

hi.. i have created a spreadsheet... ready to print... when the view comes up all looks perfect... but when printing the gridlines are not all there

ESCRIPTION: I have a .csv product file and one column has pricing data and the column next to it is empty. I need to fill in the data that matches the pricing column. For example if one of the box is 22.99 I need the empty colum box on same row to be certain number. And if another box is same price then same number gets filled. But if it's different number different number is filled and so forth. 1. Do you see column P (Header is Variant Price) 2. Next to the column on the left is column O (Header is Variant grams) (So you can see that it's filled with 136 right) 3. I have to basically fill the column O (variant grams) that corresponds to number range 4. So let's say if column P has number range from 1-8.99 I need the corresponding column on left (O Variant grams) to be a certain number. So same row, and so forth 5. Column O is prefilled with 136 and the following range will be used to fill in the Column O boxes and delete 136 (if it's 136 then just it will not delete it) range 0 - 7.99 = 136 grams (word gram will be omitted just need it to be a number) 7.99 - 14.95 = 226 14.96 - 26.95 = 317 26.96 - 35.95 = 431 35.96-53.95 = 1360 53.96 - 64.95 = 2276 64.96 - 74.95 = 2948 74.96 - 1000 = 3175 These are temporarily ranges, but as my shop prices and shipping weight changes, I'm hoping the formula or vba can be easily changed by me SO UPDATE... I did a session and got this formula =IF(P444<14.95,226, IF(P444<26.95, 317, IF(P444<35.95, 431, IF(P444<53.95, 1360, IF(P444<64.95, 2276, IF(P444<74.95, 2948, IF(P444<1000, 3175, 0))))))) But this was wrong so need the correct one. So this is the formula I got for the second time =INDEX(Sheet1!$D$2:$D$9,COUNTIF(Sheet1!$C$2:$C$9,"<="&$P2)+1) and is accurate but not sure how to apply to the whole column.. same number shows up

Inherited an .xlm file from a staff that no longer works for us and the workbook is locked. need to unlock it. looking for direction

I need to change on cell to green when another cell has a certain input