## Matrix and kilometers

Dear reader, The Matrix below shows the distances between different cities in Poland. I have a dataset with courier services where the recipient city and …

Dear reader, The Matrix below shows the distances between different cities in Poland. I have a dataset with courier services where the recipient city and …

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 …

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.