# Archive by category Functions

## Product owner

Hi, Thanks ia dvance for your help. I am looking for a macro/funcntion that does below: Coulmn1 : Has comments that I add in each day Column2 : Maintain the …

## Excel IF function help

SYMBOL NAME PRICE 52-WK Low 52-WK High Sell/Hold ABX Barrick Gold Corporation 13.74 13.58 21.45   AGNC American Capital Agency Corp. 21.93 18.84 24.3 …

## IF Function Help

Hello! I am working with Excel 2016 on a PC. I am trying to list client information from sheet 1 (Proposal Tracking) onto sheet 3 (Client List). I have the …

## professor

I have about 20 worksheets with data in similar format. I have VLOOKUP working fine with multiple worksheets in a SheetList, to bring selected information into …

## SUMIFS function

Hello, I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a completely …

## need help urgently

Hello There, I am  PhD student and working on some traffic counting cards,  the card has 2500 rows and one column, the column has numbers from 1 to …

## Data Help

I have a data on sheet 1, with four columns (Box #, Company, Quote, Year). I am wondering if it is possible, that for instane in sheet 2 I select a …

## Cross referencing

I have two spreadsheets in Excel, both rather large size spreadsheets.  The first spreadsheet (approximately 22,800 lines) is pharmacy claims data on a …

## Excel Fuction

I need an excel function that will add up to 150 to another cell the total not to exceed 750.00 By:

## ctrl+selecting rows is bringing everything in between

Hi Excelgeeks!   I’ve been having this issue for as long as I can remember, and the long work-around is getting tiresome, so…without being …

## IF Function-IF criteria is met i need a lookup and calculation

Hi below is a basic spreadsheet for what i require.  In the RATE cells i need the following input. I want a search to be done in the REd category column. …

## ROUND values

Hello everyone! We have a list of prices and we want to round the prices and apply specific rules to the intervals.If price finishes with numbers in …

## The word “figure” is being pasted over

Hello,   I am working on excel 2016 and I have been trying to copy cells from excel to word 2016 by using the paste special function:  paste …

## combinations adding to or close to a desired sum

Excel 2010 on Windows 7 I am an excel dummy when it comes to analyzing data.  Here is what I have been trying to work on.  I have an accounting …

## Vlookup or if

<!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–>     up front/ annually quarterly/monthly \$1,000 \$4,999 5% …

## change first letter to a B from a A in one go, or can i only do it indivdualy

A9-1A A9-1B A9-1C A9-1D A9-1E A9-1G A9-1H A9-1J A9-1K A9-1L   A11-1A A11-1B A11-1C A11-1D A11-1E A11-1G A11-1H A11-1J A11-1K A11-1L By: martin …

## Is it possible to create a range of values evenly distributed in rows of column from single value

Hello,    Is it possible to create a range of values evenly distributed in rows of column from single value? For example: from the value of 35, I …

## Data Attributes in Excel

Hi, I want to ask if there is a way to “tag” cells, rows or culums with attributes, and then reference them in formulas, either on the same sheet …

## IF Function Question

I am trying to determine thw proper IF function equation for this problem – I have tried it numerous ways and keep coming up with a #VALUE! error. I need …

## excel data entry

Hello, I need some help in excel.  I’m working on an inventory sheet. When new inventory comes in it will be recorded in this sheet. this is on a …

## Nesting a Mode / Vlookup function

So I have a table: Column B has a list of initials (of people) Column E has the number of the box they used that day (only values from 1-14) (the whole table …

## Multiple Conditions in an IF Statement

Hello.  I am trying to write an “IF” statement that has multiple parts and coming up short. The 2 conditions are:   if cell K13 is blank …

## Comparing values of two columns

Hi Guys!    I’ve run into a problem when comparing data values of different columns in excel.  I am trying to compare two data sets to see …

## IF , Vlookup function help

i have a certain reimbursement rate for certain zip codes.  There are 2 levels, rural and super rural.  Each has its own rate of reimbursement. …

## Excel

What if i select anything from a dropdown column. i want another column to also fill with my desired value according to the value i give in first column  …

## database officer

is there an easy way to get excel to send an email to a recipient when a due date for something is near or has passed? for example, if a due date cell says …

## Personal Mileage

Hello, Please help i am currently trying to figure out the best formula to use when calculating cumulative mileage claims, for example if Mr A has driven 9500 …

## IF, OR Formula Help!

Hi I need to create the following formula in Excel – please can you help! If A2 is less than 5 OR A3 is equal to or greater than 3, then A4 should read …

## IF Formula if Time is Greater than 10am

Hi, Here is my issue. In column “F3” I have a import time in the format 09:00. In column “T3” I’m trying to create a formula …

## IF Function

I have column a which has dollar figures in it. I have column b which I want to have a formula to fill in.  That would be If amount in column a is less than …

## Rounding values in a VLOOKUP function

Hello all. In the spreadsheet below I am using the values from the table and an inputted value (yellow box) inside the formula =VLOOKUP(B16,F15:G29,2,TRUE) to …

## Dragging data from a ‘selected’ sheet into another

I have a workbook which consists of 13 worksheets – a summary  sheet and then 12 sheets , one for each month of the year. Each month, I populate the …

## How to Sum a Range of Cells by Background Colour

Just recently I was asked if it was possible to sum a range of cells by their cell colour, rather than counting the number of cells with a matching colour. …

## How to Return Absolute Value of a Number in Excel

To return an absolute value of a number in Excel requires the use of the ABS Function.  An absolute value of a number is a the number without its sign, for …

## Count Excel Cells that Contain Data

To count how many cells contain data in Excel you use the COUNTA Function.  Using the COUNTA Function will only count the cells that are not empty. The syntax …

## Find Highest Number in a Range using Excel’s MAX Function

To quickly find the largest number in a range of cells you can use Microsoft Excel’s MAX Function that will quickly tell you the minimum number from a …

## Using Excel’s MIN Function

To quickly find the minimum number in a range of cells you can use Microsoft Excel’s MIN Function that will quickly tell you the minimum number from a …

## Using Excel’s AVERAGE Function in Excel

Microsoft Excel comes with a great function, AVERAGE, that will quickly average a range of cells that you specify. When you average numbers what you are doing …

## Adding a column in a IF function

i have an overview page. i need to add an entire column from a differant sheet if it says a certain word. the column will have 4 differant words i need to add …

## How to use SUBTOTAL Function in Excel

Excel’s SUBTOTAL function can dynamically count records in a list that has AutoFilter activated. It can also show you other information about records within …