## manu

need help in advace axcel & vba By:

Microsoft Excel Formulas in Excel

need help in advace axcel & vba By:

Using Windows 64 Excel 2010 I have medication every day I am trying to set up a sheet that shows how many tablets that I need to take when I go away some times …

I am not sure if this is possible, but I’m trying to write a IFERROR INDEX MATCH MATCH formula with a consecutive answer. I have some multiple cells with …

Any explanation regarding below – really welcome. =COUNT(‘433Up’!$F:$F) &” wk YTD Summary” …

I have a list of kids with fields to the left with “X” in them if they raised different amounts of money. I want to know the formula to list …

I currently have one column with just the currency, and another column with the currency value. I would like to combine the two so that the result would be a …

Hello, We have some daily deliverables and few same work done by multiple employees.So how can we allocate same quantity of work to each Thanks …

I am trying to create a series of one of my criteria to copy across the rows of my spreadsheet. The criteria is a date range. I am currently …

I am using excel 2011 for mac. I need to convert mm to inches. I know the formula for converting one number in a cell that is in mm to a number in inches but I …

Hey, If i have a cell range for foreg: a1:a100 and b1:b100 and i want to know if a1+b1=7 for each row and get the countif value that total 26 cells return with …

I am wanting to create an automated General Ledger and Journal Entries. The way I am wanting to set this is up is having a list set up that a user can choose …

I am using Excel 2016. I added four new rows to the middle of a lookup table. These rows ARE included in the formula. …

I have a sample like this where I want to find nearest value to average city and weight are two separate columns city weight A 23 A 22 A 45 A 97 B 34 B 22 B 23 …

Hello, I am looking to find some basic guidance on using Excel to create a sheet where I will be able to input one of our clients credit field to …

I am trying to use a simple COUNT formula. for example =COUNTIF(AG13:BE13,”>60%”) However my information is in …

Hi, I have an issue. Lets say I have 4 numbers (10, 50, 100, 250) and I want excel to give me the best combination of those numbers that will get me as …

Hello guys, i need help calculatin how much money has been paid for a specific transport company for a certain month. For example sum the last columnt if the …

I have a grids and I know the costs of the item, in all of the four corners I want enter each corner with a figure and I would like excel to calculate the mean …

Hi! I hope someone can help me with this question. I am trying to calculate the standard deviation of a row of cells, however i would like to not include any …

I need a formulae to work whereby if a time is over 8 hours then the result of cells E10 minus E8 needs to be applied. Tried various way of acheiving this but …

I want to rearrange the column in excel with numbers in terminal dogit order. for an example i want it in 00001 00011 00011 00111 01111 00021 now its in …

Hello, I’m trying to figure out a way to make my forecasting easier. I get a pdf that I convert into an excel file. The dates available for what …

Good day. I have attempted many formulas to rid the cells of the ‘false’ statement that appears. Please share what can I insert into this formula …

Hi, I’m running into the following problem, I’d like to split my text from one singel cell (split by comma’s) into multiple columns. I want …

I have a skills matrix for employees that I wish to add a formula to in order to warn us when certain certificates for skills expire. I currently have the …

Hello, I hoped you could help me with an issue I still haven’t gotten my head around. I am working with a table that shows the uptime in …

I am needing help with the following I have spreadsheet that states employees hire date and formula to calculate that date to current date which auto generates …

Hello. I want to achieve the following. User selects the item they want in A1 (dropdown menu), called ITEM1 In the second sheet, there are tables with …

I am trying to figure out projected days left minus tasks per day Days – tasks (1 day equals 10 tasks) = days left Help please By:

Hi, I am bit stuck on a time funciton. I have two times a1= start time and b1 = finish time. C1 tells me the differnece in time as I have …

Hi All, I need to be able to search data were we have 1 client with multiple expiry dates of policies. We need to pull the data of the oldest …

Here is what i am trying to do….is there one formula that would work? In J2, I want to sum L2:R2 where the value of any text is = to ‘1’ …

I have a lot of formulas, which means I want to know what they said and for what it is done. like :- =LOOKUP(Answerkey[[#This …

QNTY PIECE MARK SIZE DESCRIPTION LENGTH LENGTH TOTAL LENGTH (FT) FT IN FT 1 1C1 W8X21 COLUMN 4 4.375 4.36 4.36 1 1C2 W8X21 COLUMN 4 4.375 4.36 4.36 5 …

Hi, I want to make the information in some columns (but not all) displaying in rows, please see below an example. This is what I have: …

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. …

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 …

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.