## functions

Fill the “Needs contacting?” column with YES or NO taking into consideration that the customer needs to be PAST DUE (due date <today) and NOT be …

Fill the “Needs contacting?” column with YES or NO taking into consideration that the customer needs to be PAST DUE (due date <today) and NOT be …

I WANT TO GENERATE RECEIPT FOR HOME[RS.100] WHICH CONTAIN LAND[RS.60] AND CONSTRUCTION COST [RS.40]. WHEN I RECEIVE RS. BELOW 60 ,MENTION”LAND”,AND …

I HAVE A EXCEL SHEET LIKE THIS GIVEN BELOW …

Hi, I am working on a project that requires me to merge two datas in one. I am currently inserting cells then copy pasting the data, which requires a …

I have 2 worksheets. One is just a templete of what i want to copy over from the other worksheet. The other worksheet has over 900 rows. i want to transfer …

I am using Excel 2010 and could you please help me with the following request. Suppose A1 to E1 each contains as follows: A1 CAT …

I need a VBA sub that will use the title of a sheet to find the matching text on another sheet and use that text as reference to retrieve other data in the …

I have a table of Occupancy ratio and prices for a hotel Column A Column B Occupancy Price …

ЧАСЫ НАПОЛЬНЫЕ http://workle.website/5n By:

Formula to confirm if a cell in an excel spreadsheet is colored with answer”yes or no”. By:

I am trying to creeate a spreadsheet which will work out a certain value for myself. I am trying to figure out how I can do the following: If (such a …

I am trying to creeate a spreadsheet which will work out a certain value for myself. I am trying to figure out how I can do the following: If (such a …

I need an excel formula to let me know, the # of cells where column B is blank but only if column A has content By:

Hello, I would like to know to make an Object move up to varying points (Left and Right), depending on date values within specific cells. …

Hi, Im trying to comfine a COUNTIF and IF function into a single cell. Indivudually, the functions work, but I just needthem to work together Im scoring …

I would like to ask for two things How to get a linked image from 3D visualization which change everytime I update the 3D Map How to mangage color distribution …

Hello, Well I’m stuck. I’m trying to write a formula using the IF and AND functions that ought to be simple, but just can’t make it work. …

I have two tabs, lets call them White and Black. In White I will record data, I.E cell A1 is a name, Chris. cell B1 is a number, 200. cell A2 is …

I need to filter from two columns (name and date) select the value from a third column. Name can be matched exactly, but the date filtering is more tricky …

I have the following data in a .csv file that I import into Excel, once that is done I need to be able to create a 3D Bar Graph of that data. Date, Time, …

i have two sheets one is sample another one is RTF, when i update value in RTF sheet its has to automatically update in sample file, the only thing is , there …

hello, I am having trouble writing out a lookup formula where if a certain text is located in a cell, then i want to look up another value in another …

Hello, I’ve been trying to search for solution for hours now, and yet still can’t find it. So I really hope someone could help me. So here is what …

I have a 2 rows in excel table.- 1st row is for Month and 2nd row is for score. The table is dynamic that a new month is added after every month. I need a …

Hi all, I have excel where I try to create graph based on certain values range. I use MATCH-function to create range based on date given in excel. For example: …

Hello, in a project list I have projects that range across the categories A, B, C and D. One coloumn auto-generates a project code according to a range of …

Hi, As written in the title, I want to copy past (similar to dragging down the formula) from a cell above if another specific cell contains a specific …

I need to find out what formula to use , In cell F14, enter a formula that will calculate the total number of employees scheduled to work Sunday …

Good day I am looking for a formula (I suspect that it would be a logic formula if, then) to help with the following. I have three columns Column A with …

Question regarding find the last friday of every month What I did: Downloaded an excel file that showed the daily closing numbers of the S&P 500 from 1997 …

I’m trying to create a report on excel that produces a red light, yellow light, or green light (all pictures) based on if an inputted number is lower, …

Hi everyone, I was wondering if someone could push me in the right direction regarding how to build a formula. I am looking for something to display …

Hello, I have a googlesheet not an excel (gasp*/sorry!) I have a data table that i’m extracting data using various if statements. I have …

Hi all, I’m trying to get excel to add or subtract 2 cells, as I have live stock data in one of the cells which has example $288.19, when I try add the 2 …

My Data is like this Customer Id Date Product 123456 2/16/2018 Book 123456 2/16/2018 Book 123456 2/17/2018 Pen 123456 2/17/2018 Book 123456 2/18/2018 …

How would I find an IF statement if I also need an AND statement? Ex. “If any of the numbers in cells B1, C1, D1 are equal to 5, multiply them together, …

In sheet 1 column D if I put yes then I want to all data entered in Columns A, C, F, H, I, L exported to another sheet 3. After this everytime I enter …

I need automated formula to create a chain of local brands X,Y,Z for the same global brand A Global brand Local brand Global Brand …

Excel Version – 2016 Need to write a macro to add a 3 new columns in the exiting excel file with exising data. First Column should have a …

i have 2000 Multiple choice questions with 4 options, in Excel sheet. i want to present them in Powerpoint with animation. please give some tips. …

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.