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

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 …

What formula would be required to show the total amount, say £175.50, in words, one hundred and seventy five pounds fifty pence? I’m using Excel 2010 …

A very popular, and often used function, VLOOKUP is a fantastic tool in Excel. The VLOOKUP Function in Excel is used to look for user specified data in …

The DATEDIF function in Excel will calculate the difference between two dates, showing you the answer in days, months, or years depending on how you specify it …

The IF function has the following syntax: IF(logical_test,value_if_true,value_if_false) My questions is,If I don’t want the function to take any action …

what is the reason for using the “–” symbol in a formula such as

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.