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

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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

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

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 …

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

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 …

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 …

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 …

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

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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

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 …

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 …

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 …

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 …

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 …

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 …

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 …