## Function problem

Dear Excel Geeks, My problem is probably a minor one, but I am new to excel and the problem drives me nuts. I am using Excel 2008 for Mac, and I am …

Dear Excel Geeks, My problem is probably a minor one, but I am new to excel and the problem drives me nuts. I am using Excel 2008 for Mac, and I am …

Here is my prediciment…. I’ll create an example Column A Column B Column C Job Primary Alternate Sweep Joe Katie Trash Katie John Mop Erica Joe …

I want to conditionally format cells that have a day of the week in the cell, although the cell has the entire date. So in a column, i have all days from 1st …

Does anyone know how to create an “AllDateinperiod” filter with dynamic dates. Autofilter only allows filtering by month and quarters, I want …

Hi there, I need to anonymise one worksheet within my entire excel document. I can’t have anyone reading what is in it as it’s for data protection. …

Hi Guys, Hopefully this will be easy for someone slightly more Excel bright than me? I have 2 sheets.. Sheet1 has a column of ID numbers which I …

Hi, I would like to create a calender were the days of the week are fixed and the cell below the days of the week are expressed as the date. Each time I …

The results of a lengthy DATEDIF FORMULA to calculate continuos sobriety is: 29 years,4 months, 28 days, 21 hours, 20 minutes, and 10 seconds …

If an incorrect zip code is entered in cell B4, cells C6, C7, C8, and C9 will display the #N/A error value. Use the IFERROR function to modify the formula in …

I want to add up the quanities and consolodate all the fields into 1 field. for example below has item numbers on the left and i want to to make each item …

Is there an excel formula(s) to take the information in a table and put it in list?A sumifs formula works to create the listing by using named ranges. ie: …

I have an attendance spread sheet for subjects: Day Monday Tuesday Wednesday Thursday …

Hi, Please can you help with a simple formular. I ve got a spreadsheet with a large data. I want to get specific data from that spreadsheet to another …

Is it possible? excel By:

I am running Windows 7 operating system Dataset 1 is for period 23/6 – 29/6time of data snapshot is 9am 1pm and 4pmDataset 1 has 3 columns of data …

Is it possible to bind a colour to a key combination say “Ctrl+Shift+L” to fill the cell with a specific colour? If yes please help with the …

HOW TO GET L1 TEXT DATA IN B1 IF A1 TEXT & K1 TEXT IS SAME? By:

Hi, I have two spreadsheets that i want to link together. In spreadsheet 1 in cell D10 i want to get a total from spredsheet 2 but i am unsure how to do …

I have an excel 2010 sheet that is getting rather complex. I want to add a column on sheet one that has a checkbox. if checked I want it to …

Hi Excel Geek, i’m trying to do something using countifs but i am not able to do it, is it posible to use countifs and in the criteria input a …

How do you get an Excel spreadsheet to continually reference the previous sheet? I have a Monthly Expense Report workbook and I need each sheet (month) to …

I have created the following forumla to help make a drop-down list serachable: =OFFSET(F7,,,COUNTIF($F$2:$F$52,”?*”)) I think named this …

When i insert lots of velues in excel and give command of round function say 6 * 10 instead of 60 it shows 59.10………… it’s …

Good day, I’m using excel 2007 and I’am new to excel. As a student this is my first time I encounter excel wherein we are ask to use …

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.