Get instant expert help with Excel and Google Sheets

pivot table and help continuing where the project left off

i want to learn how to use the if function with a time value

I have a column that includes first and last name (lets say column A) and a column that identifies if they should be included with a yes or no (Lets say column B). i'm trying to determine how to make a new column (C) only display the last name from column A if Column B equals Yes. I've pieced together some formulas, this one gives me just the last name: =RIGHT(D11,LEN(D11)-FIND("*",SUBSTITUTE(D11," ","*",LEN(D11)-LEN(SUBSTITUTE(D11," ",""))))) But when i add this to a IF logic test it doesnt work, help please... =IF(E5="YES",[RIGHT(D5,LEN(D5)-FIND("*",SUBSTITUTE(D5," ","*",LEN(D5)-LEN(SUBSTITUTE(D5," ","")))))], [""])

Anybody online? Have a problem relating to firstname,lastname.

Hello, I'm looking to set up a spreadsheet that displays all the items that come in. I'm not sure what formula to use so that when I type in a number for example 20, then 20 columns loads up. I basically want a professional looking "Goods Inwards reject action form". Any help would be greatly appreciated

I need to find out one vehicle filled fuel more than 2 in a day from excel datas

hi, I am stuck on a pivot table, please help me

trying to find a formula that will auto populate when a specific text answer is filled in a previous cell

I am trying to use the excel function AVERAGE for four data slots. When I use the function, it is not taking the average, but instead just leaving me with the four terms added together.

When I open excel, the worksheet doesn't show (the screen is grayed out) and most of the task bar options are grayed out as well.