Excel 2010 Related Problems & Solutions

99 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 30 of 99
what is wrong with this If Statement? thnak you
Summary: I am trying to submit a multi if statement and vlookup. here is what I have but not working =IF(ISNA(VLOOKUP(C122,ProjectTracker!$A$1:$AV$118,3,FALSE...

How to extract 1 date from a cell with multiple dates?
Summary: I have one cell with a date range and need to have each date be extracted to a different cell. message edited by sarahh770...

[Solved] Copy entire excel row to a new sheet if a value is true?
Summary: I need a code for the follow scenario: Also if you can kindly help with how to input the code. Thank you in advance. My Sheets are Titled: Sheet 1...

[Solved] How to lock buttons & textboxes on a work sheet?
Summary: LOCKING CONTROL BUTTONS IN PLACE..USING ACTIVEX OPTION BUTTONS, TEXTBOXES, LABELS AND COMMAND BUTTONS ON AN EXCEL WS...WOULD LIKE THEM TO STAY WHERE I...

Excel Formula needs to add Index to return cell information
Summary: Hello, Currently I am working with two tabs of data that do not have the same unique identifiers at the same time. I am using a series of functions ...

[Solved] Change number in a formula buy referencing a different cell
Summary: Basically I have this formula: =(MIKE!$B8) and I have a bunch of cells withs Numbers like so: Cell | Cell Number Change C1 | 10 C2 | ...

How do I add rows of data to new worksheet from data dump
Summary: Hello. I am looking for copy data based on criteria into a new work sheet and format it at the same time. My data is a database dump with thousands up...

[Solved] Return a number based on today's date compared another date.
Summary: I need to return a number associated with a date based on today's date. For example: A1:A24 are numbers 1 to 24 and B1:B24 contain the 15th and 30th f...

[Solved] Look for matches between 2 worksheets in Excel 2010
Summary: I've been attempting to write a macro to do a comparison with a copy function when a match is found. Hopefully this helps explain it: Situation: Work...

[Solved] Drop downs not showing in document on my Excel
Summary: I am using an EXCEL '10 from my employers to use for reimbursements. They have included various drop-down menus on the sheet but no drop down appears ...

[Solved] Windows Excel 2010 Starter fails to start
Summary: Have tried restore to earlier date with no luck. It was working last week and I have restored back past an AVG update today. ...

hyperlinks suddenly stop working error message can't locate
Summary: excel 2010 have adjusted trust centre settings and made Internet Explorer home search....................................................................

[Solved] Relocate specific rows within the same worksheet
Summary: I need a macro that will find rows that column K shows "X", then cut the rows and insert them further down the same worksheet below a merged row highl...

[Solved] how to get data to correspond to text
Summary: I am working on a spread sheet in Excel 2010. The first column has over 1,000 cells and 5 different items in it. The second column has the price of t...

[Solved] excel 2010 how to freeze and unfreeze headers
Summary: I am working with excel 2010 spreadsheet and i will like to know how to freeze and unfreeze headers so i can see the heading as i scroll down my spre...

[Solved] how to get weekly and monthly totals from horly totals
Summary: how do i get weekly and monthly totals from hourly figure totals and monthly hourly overtime totals that are the same in Excel 2010 message edited by ...

[Solved] Formating to a date Excel 2010
Summary: Hi everyone This might be an easy one for whoever knows it I have a number 8202014 I need to format it as a date to show 08/20/14 And the formula shou...

[Solved] How to find the same numbers in Excel 2010
Summary: I have two columns of ID numbers, A1:750 and B1:750. In each columns there are some IDs that are the same but also some IDs that are different. When a...

[Solved] How do I BOLD specific text string in a Concatenate formula?
Summary: Using Excel 2010 Do not want to use VBA, if possible. If this request is not available in 2010, is it available in 2013? ...

[Solved] Amount greater than, but less than
Summary: What is the Excel 2010 formula for the following scenario: Income is $162,000. I need to calculate the amount that is greater than $90,000, but less ...

excel 2010 How To Turn Off Auto-Hide Ribbon
Summary: how can I switch on/off auto-hide in excel 2010. while I'm typing the toolbar is hided, but when the mouse is placed on the top of my program it switc...

[Solved] how can i track a due date on ms excel 2010 spreadsheet
Summary: I am trying to keep track of due dates on my spreadsheets. I have some dates that expire annually and the others biennially. ...

[Solved] If statement using data validation in Excel 2010
Summary: I am trying to use the data validation function to allow certain range of numbers based on a particular category. Category Range Allowed Superior >3.5...

[Solved] Excel 2010 jumps to File tab whenever a format is changed
Summary: In EXCEL 2010, ON the HOME Tab, Whenever I change any cell format from the CTRL+1 pop-up, eg font size, Decimal places fill etc, Excel jumps from th...

[Solved] Keep a running total of a growing spreadsheet
Summary: So....a friend has a spreadsheet that will be growing daily with new data and on one row, he'll have the totals of all calls that he wants to sum auto...

[Solved] How do I remove trailing zeroes in Excel 2010?
Summary: How do I remove trailing zeroes in Excel 2010? I want to remove the last two zeroes from the entire column. For example I want 703100 to look like 703...

[Solved] how to copy file with macro module
Summary: My ex-colleague create invoice using ms excel 2010. In year 2013, my colleague create the invoice start fr worksheet name 13-001, 13-002 .... until ...

[Solved] copy file from microsoft excel2010 to another workbook
Summary: hi, I am using Microsoft excel 2010. When I copy a file to another workbook . My currency in words become #NAME? . but when I go to that cell the for...

[Solved] Adding totals from multiple ws according to employee name
Summary: If you've already answered a similar question for me, I apologize but I cannot figure this out. I have a workbook that has 13 pages, Jan, Feb, Mar, Ap...

[Solved] How to format a cell in Excel 2010 when selected
Summary: I am going to use a macro with relative references to copy a range of cells from one workbook to another. As such the user must be in a specific cell...

1234


Ask Question