#logicfunction

Hi Everyone, I am trying to figure out how to find out when a client on my clientele list first visited our shop. Below is a sample table to give you an idea of what the clients list would look like and the date format that I am currently using. ABCDEFGHI1Client NameDatePaymentUnique...

Hi everyone, I have a list of clients called "Client_Clientele". Another list named "Client_Phone" which holds all of their phone numbers associated with those clients. Another list named "Client_Email" which holds all of their emails as well. I am trying to make a formula work, so that when...

Hi Everyone, I have a table that calculates the revenue and expenses per quarter of the selected fiscal years. For the selected fiscal year, its easy to get what the profit percentage is for the quarters. But I want to be able to calculate the profit percentage difference is for the selected...

Hi Everyone, I recently created a table that counts based on the raw data available. Unfortunately, when I created the formula to find the average, I based it off of a table which already summed up the raw data based on month and year. I would like to modify the formula to find the average...

Hi everyone, At the moment I have this spreadsheet which I am using to calculate the income services and business expenses per category. It works great but I have been struggling to make work how I need it to function exactly. The table where all the services & expenses are summed by category...

Hi Everyone, I"ve been trying to figure out how to do this and been stuck for over a week. I created this custom report table, which works great. But the problem, I'm having is if I enter a "Start Date" which has a different year then my "End Year". It doesn't include the data from the...

Hi Everyone, I"ve been trying to figure out how to do this and been stuck for over a week. I created this custom report table, which works great. But the problem, I'm having is if I enter a "Start Date" which has a different year then my "End Year". It doesn't include the data from the...

How to Highlight RAW After Bold Text ??? "E2" cell text is bold after Highlight raw on red color with white font & bold also

(NEED THIS CONDITION) C2= "20 ft" use 5,00,000 C2= "40 ft" use 10,00,000 Change value According "20 ft" Or "40 ft " ------------------------------Kindly Suggest Right Formula-----------------

Hi Everyone, I have this formula that I use to pull a certain data while referencing certain cells.... Here is the formula: {=IF(B419="","",IFERROR(INDEX('Work Orders'!N:N,MATCH(1,IF(VALUE(D419)='Work Orders'!AC:AC,IF("Canceled"<>'Work Orders'!K:K,IF('Work...