## formula help

I have text in A1 that I am trying to locate with text in column B. the cells in B contain more text beyond what I am looking for in A. I need it to find A …

I have text in A1 that I am trying to locate with text in column B. the cells in B contain more text beyond what I am looking for in A. I need it to find A …

Column A- list of accounts Column B- list of managers Column C- a smaller list of accounts that should be in A I need to compare columns A and C, then …

Hi, i have 2 rows with same ID, i want to compare the columns start date or months, when teh ID matches, i want the result as those whose start date is greter/ …

how to search data in one excel cell meaning if my data shows 0202 cat 0203 dog 1017 duck 1022 horse and if i type ohr or the number that …

Hi How do i get Sheet 2, A2 to copy Sheet 1,A2 if Sheet1,G2=Won Thanks in advance. By: Craig

I want to find out the hourly rates of employees by looking up at their skills and experiences.I have a separate dataset in which all the data of the employees …

TOTAL MZN ZAR USD 200 200 200 No Date Currency Narrations Debit Credit Balance MZN Balance USD Balance ZAR 1 1-May-19 MZN Income 100 100 2 …

hello, I am trying to figure out an excel formula for the problem below. If Apple with the condition number of 23, and 23 fall between min/max range from …

Hi, I am trying to create a cell that shows whether a project is on track, late or ahead of schedule using multiple dates derived from multiple tasks within …

Hello there! I need help with the VLOOKUP formula, can anyone help out? Many thanx in advance! I can upload a file, so it will make it clearer. Emanuela …

I have multiple columns of info that I need condensed into just one column. However, I also need that one final column to mention the info only once. In other …

Hi I have 2 sets of data. I want to tally the amount of times one is greater than the other. For example …

IF I HAVE TWO SPREADSHEETS AND I WANT TO FIND WHERE: IF VALUE IN “SPREADSHEET 1” COLUMN A MATCHES A VALUE IN COLUMN A IN …

I have a spreadsheet with columns representing the months of the year. What I need is formatting to change the color of the font after the end of that …

Hi, I have the following formula: …

i have 3 shifts A shift is from=6:00-15:00 B shift is from=13:00-22:00 C shift is from=21:00-6:00 excel should automatically …

I need to retreive the value from the last non blank cell in a set of cells (not on the same row or column), so, I use this formula: …

I am struggling to create a conditional format formula that highlights the following; – Highlight any rows of the cells within Column B …

I have a list of 20 checks. I am looking for 8 that equal $1128.25. Is there a formula applied to the 20 to find which 8 give me my total? Thank you for your …

I am trying to create a formula which will find all of the students in a particular program by subject code. My formula works if there is just one …

Could someone break this formula piece by piece and explain how it works to me? it works appropriately in my file, but I am unsure how exactly it works. …

find the bonus.if sales greater than or equal to 500000,bonus is 0.5% on sales, otherwise enter zero. By: OSHADHI DE

Hi, Please I want to know the formula if the rersponse received within 12 calnder days to give check mark And if more that 12 calender days to give X as …

Hello, i know there must be a simple solution to this but cant figure it out atm. I have a table that i added to data model and then take out graphs from. The …

How do i Express the following multiple conditions in 1 formula IF A1=10 and B1=15 then C1=Apple Else C1= Orange IF A1=20 and B1=25 then C1=Tomato Else C1= …

Hi Everyone, I have two drop down one will have the values of all month that is from January to December other one is dependent dropdown will have values of …

An API returned the following result: { “Global Quote”: { “01. …

So what I’m doing is hyperlinking my summary page items with each worksheet in the workbook. I’m getting an error in my code on the last line …

I want to have the date auto fill in column G when the word “Complete” is in column F and want it to stay that date. How do i do that or can that …

I am trying to create a spreadsheet that will total the number of hours spent in work during each month and give me the monthly average based on the number of …

I am setting up a workbook for tracking some video game elements for a friend. It’s set up with a couple cover sheets that pull data from 100 …

Hey guys, I’m looking to my Google sheet has varies columns with values inserted in the rows (62 rows). I want to insert a few rows to represent what …

Hello: I am trying to create a formula that will search two columns of data. Each column is on a separate sheet within the same workbook. If …

RIght now I have a workbook that has a masterlist of data that updates another worksheet for the first quarter. We need to create a third worksheet for …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

Hi, I’ve got 2 sheets with common column A. If the cells in column A of sheet 2 match that in sheet 1, I want to copy the data from sheet 2 columns B-J …

I need a formula to count distinct IDs based on category and the date the category was added is less than 30 days Data structure: Column F – …

Current formula i am using: …

A company works out the monthly pay for sales staff using the equation y = ___x 10 + 600, where y is the monthly wage (£) and x is the …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.