Browse E

Excel - question on formula for dates Hi there, I\'m trying to put together a wo

Excel - question on formula for dates Hi there, I'm trying to put together a worksheet of personnel available for projects. I've created below a table that shows a section of my e…

Excel - question on formula for dates Hi there, I\'m trying to put together a wo

Excel - question on formula for dates Hi there, I'm trying to put together a worksheet of personnel available for projects. I've creeated below a tablee that shows a section of my…

Excel - sum items from one column based on search from different column I create

Excel - sum items from one column based on search from different column I created a spreadsheet with figures in column D and a category description in column F. I want to sum the …

Excel -Chapter 2-Working with Formulas and Functions Matching Drag the letter fr

Excel -Chapter 2-Working with Formulas and Functions Matching Drag the letter from the list on the right to its matching term in the list on the left. When you are finished, click…

Excel / Calc Assignment 1 In this assignment, you will create a spreadsheet for

Excel / Calc Assignment 1 In this assignment, you will create a spreadsheet for a small home business which is selling three vitamin products: CoQ-10, Iron, and Zinc. The owner wa…

Excel 2003 Sumproduct #name error I am using an old version of excel 2003 and I

Excel 2003 Sumproduct #name error    I am using an old version of excel 2003 and I am having problems getting a formula to work out how many entries exist when users search betwee…

Excel 2007 - when trying to print getting error: \"Print titles must be contiguo

Excel 2007 - when trying to print getting error: "Print titles must be contiguous and complete rows or columns." Original title: Print titles must be contiguous... I have a workbo…

Excel 2007 - when trying to print getting error: \"Print titles must be contiguo

Excel 2007 - when trying to print getting error: "Print titles must be contiguous and complete rows or columns." Original title: Print titles must be contiguous..... I have a work…

Excel 2007 I need help getting a macro to draw from a range with multiple column

Excel 2007 I need help getting a macro to draw from a range with multiple columns Hi, I am trying to edit a macro in Excel 2007 that copies a range and pastes it into a new range …

Excel 2007 I need help with editing a macro that sorts a range of data and autop

Excel 2007 I need help with editing a macro that sorts a range of data and autopopulates 5 columns but I would like it to expand to 27 columns Hi, I am editing a macro in Excel 20…

Excel 2007 Nested Rows Hi I would like to build a spread sheet to record and man

Excel 2007 Nested Rows Hi I would like to build a spread sheet to record and manipulate costs for the products we manufacture. My stumbling block is how to 'nest' my data. Probabl…

Excel 2007 VBA Case Function Hi I have many IF in a formula and I want to change

Excel 2007 VBA Case Function Hi I have many IF in a formula and I want to change this for a function in vba The results will be different message in a cell depending of the select…

Excel 2007 spontaneously formats entire work book in date format -- seems to be

Excel 2007 spontaneously formats entire work book in date format -- seems to be a bug -- is there a solution? Hello, I am having a problem with Excel 2007 which I infer other peop…

Excel 2007, How to find all cells reference number of a text Hi^_^ Need to find

Excel 2007, How to find all cells reference number of a text Hi^_^ Need to find the Rows number for a text. In Cell P3 we type the phone number we need to search When I type the p…

Excel 2010 Drop-Down disappears when file is saved/reopened I have a workbook cr

Excel 2010 Drop-Down disappears when file is saved/reopened I have a workbook created in Excel 2010. I used Data Validation to create a drop-down list in a cell that uses a differ…

Excel 2010 If Statement Excel 2010 The Spread sheet has over 264,000 rows of dat

Excel 2010 If Statement Excel 2010 The Spread sheet has over 264,000 rows of data. Its data by the minute for 6 months. Two of the columns are: Time - Hour and minute of the day R…

Excel 2010 Macro help needed Hi, I have a worksheet that holds data in column C

Excel 2010 Macro help needed Hi, I have a worksheet that holds data in column C starting at C9, the amount of rows from C9 down holding data varies so this not fixed. I'm trying t…

Excel 2010 VBA Code to Paste-As-Values a block of columns one-by-one I need to c

Excel 2010 VBA Code to Paste-As-Values a block of columns one-by-one I need to copy B1:BZ100 as values, ending up in the same B1:BZ100 location (actually, the end row is a dynamic…

Excel 2010 VBA Code to Paste-As-Values a block of columns one-by-one I need to c

Excel 2010 VBA Code to Paste-As-Values a block of columns one-by-one I need to copy B1:BZ100 as values, ending up in the same B1:BZ100 location (actually, the end row is a dynamic…

Excel 2010 formula in series values, need to update as user specifies I have a n

Excel 2010 formula in series values, need to update as user specifies I have a number of graphs in the Excel 2010 spreadsheet that I am working on. I have a cell in the first tab …

Excel 2010 formula in series values, need to update as user specifies I have a n

Excel 2010 formula in series values, need to update as user specifies I have a number of graphs in the Excel 2010 spreadsheet that I am working on. I have a cell in the first tab …

Excel 2010 formula in series values, need to update as user specifies I have a n

Excel 2010 formula in series values, need to update as user specifies I have a number of graphs in the Excel 2010 spreadsheet that I am working on. I have a cell in the first taab…

Excel 2010 formulas paste: changes when edit formula I am trying to use a formul

Excel 2010 formulas paste: changes when edit formula I am trying to use a formula to count the number of cells with information on one tab and insert on another ( =COUNTA('Week 2'…

Excel 2010 macro issue on tab. Original title: Excel 2010. Hello there, I have t

Excel 2010 macro issue on tab. Original title: Excel 2010. Hello there, I have the following two macro's and would like it to run on specific tabs not just one tab: Sub FilterCent…

Excel 2010 tab issue, everything on my data tab is grayed out and doesn\'t work

Excel 2010 tab issue, everything on my data tab is grayed out and doesn't work I'm posting on behalf of the customer. Here is his issue on Excel# 2010. I am trying to figure out w…

Excel 2011 Mac Auto-recover file was lost???? Yesterday morning my colleagues Ex

Excel 2011 Mac Auto-recover file was lost???? Yesterday morning my colleagues Excel 2011 (on Mac OSX 10.8) crashed. He reopened Excel and was asked if he wanted to recover the pre…

Excel 2011 doesn\'t automatically convert dates from \"May 1, 2007\" to \"1-May-

Excel 2011 doesn't automatically convert dates from "May 1, 2007" to "1-May-07" Original Title: "Excel Date Format Problem" I am using the latest version of Excel (14.1.3) on OS 1…

Excel 2011 for Mac - Functions not worrking Maany of the functions are not worki

Excel 2011 for Mac - Functions not worrking Maany of the functions are not working. I have run the "Check for updates" there are none. I have gone to the adding and added solver. …

Excel 2011 for Mac Hi there i was wondering if anyone can help, i have a problem

Excel 2011 for Mac Hi there i was wondering if anyone can help, i have a problem thats driving me crazy! I have excel 2011 on my Mac and whenever i open excel it opens at a pre de…

Excel 2011 for Mac crashing when entering a formula Hi Community I have a long s

Excel 2011 for Mac crashing when entering a formula Hi Community I have a long standing problem that seems to come and go with Excel 2011 running on the Mac. I'm running Excel 14.…

Excel 2011 simple spreadsheet - NO Macros - Then Why Enable Content? I have a re

Excel 2011 simple spreadsheet - NO Macros - Then Why Enable Content? I have a relatively straightforward spreadsheet (Excel 2011) - add rows and columns. Not much more than that. …

Excel 2011 w?indow is too big to resize Ok - I am fit to be tied. I can\'t USE E

Excel 2011 w?indow is too big to resize Ok - I am fit to be tied. I can't USE Excel because when I ggo to open the program, the window opens up so big that the bottom of the windo…

Excel 2013 - Basic Number Sequence impossible Hello,.. I have a series of data w

Excel 2013 - Basic Number Sequence impossible Hello,.. I have a series of data with account numbers, email addresses and an account owner in columnns A, B & C. I have several …

Excel 2013 - Is there a way to count the number of occurrences of a specific cha

Excel 2013 - Is there a way to count the number of occurrences of a specific character in a cell? I have copied data from a scanned and OCR'd file that includes a text string with…

Excel 2013 - Lookup,Match , Sum the values and enter into the cell based on the

Excel 2013 - Lookup,Match , Sum the values and enter into the cell based on the lookup criteria Hi: I need assistance in accomplishing this task in Excel. Below is the excel sheet…

Excel 2013 - Lookup,Match , Sum the values and enter into the cell based on the

Excel 2013 - Lookup,Match , Sum the values and enter into the cell based on the lookup criteria Hi: I need assistance in accomplishing this task in Excel. Below is the excel sheet…

Excel 2013 Insert New Sheet View Issue Hello All, One of my users is having an i

Excel 2013 Insert New Sheet View Issue Hello All, One of my users is having an interesting issue with her installation of Excel 2013. Here's the gist of it: 1. She right-clicks on…

Excel 2013 Office 365 Home Premium cannot change cell or font colors i cannot ch

Excel 2013 Office 365 Home Premium cannot change cell or font colors i cannot change font or cell colors in excel 2013. I am using Windows 8 and I have never had this problem befo…

Excel 2013 Office 365 Home Premium cannot change cell or font colors i cannot ch

Excel 2013 Office 365 Home Premium cannot change cell or font colors i cannot change font or cell colors in excel 2013. I am using Windows 8 and I have never had this problem befo…

Excel 2013 Row shift I am currently use Excel 2013 and I am trying to clean up d

Excel 2013 Row shift I am currently use Excel 2013 and I am trying to clean up data in a .csv file. Attached is a picture for reference. As you can see, column B contains both nam…

Excel 2013 Userform macro issues. I am trying to get this user form I created to

Excel 2013 Userform macro issues. I am trying to get this user form I created to start on row 5 in column A. I have tried changing some of the code and it keeps out puting text to…

Excel 2013 Userform macro issues. I am trying to get this user form I created to

Excel 2013 Userform macro issues. I am trying to get this user form I created to start on row 5 in column A. I have tried changing some of the code and it keeps out puting text to…

Excel 2013 VBA, Looping code problem sending emails in VBA After upgrading to Of

Excel 2013 VBA, Looping code problem sending emails in VBA After upgrading to Office365 attached macro  does not work anymore. When reaching to the syntax : " Set olNewMail = Crea…

Excel 2013 formula to extract totals from specific rows on other worksheets by c

Excel 2013 formula to extract totals from specific rows on other worksheets by column name. Hi, I have a workbook I complete monthly for a construction company. It's direct payrol…

Excel 2013 starts up with blank screen when opened from explorer When I double c

Excel 2013 starts up with blank screen when opened from explorer When I double click any Excel file in windows explorer, Excel starts up maximized and I can see the ribbon but the…

Excel 2013 time autofill problem I have a column containing date and time values

Excel 2013 time autofill problem I have a column containing date and time values with 5 mins differences between the rows, like this: 2014. 01. 01. 00:00:00 2014. 01. 01. 00:05:00…

Excel 2013 time autofill problem I have a column containing date and time values

Excel 2013 time autofill problem I have a column containing date and time values with 5 mins differences between the rows, like this: 2014. 01. 01. 00:00:00 2014. 01. 01. 00:05:00…

Excel 2013 time autofill problem I have a column containing date and time values

Excel 2013 time autofill problem I have a column containing date and time values with 5 mins differences between the rows, like this: 2014. 01. 01. 00:00:00 2014. 01. 01. 00:05:00…

Excel 2013 time autofill problem I have a column containing date and time values

Excel 2013 time autofill problem I have a column containing date and time values with 5 mins differences between the rows, like this: 2014. 01. 01. 00:00:00 2014. 01. 01. 00:05:00…

Excel @if Problems I have a very simple problem that I just can\'t get to work .

Excel @if Problems I have a very simple problem that I just can't get to work ... I have a Contract date in column C The Return date in column D =c5=30 Today in column E Today() H…