Text colour keeps changing to grey

I'm finding that the text within several of my spreadsheets (though they were all based on one original master spreadsheet), sometimes shows as grey when the spreadsheet is opened. I'm able to get it to go back to normal by going to Tools-Options-Color-Reset, but is there any way of stopping it from doing it in the first place? thanks Sarah

Claculating Annual Turnover forma Quarter

Hi All Does anyone know the formula to calculate the annual turnover rate based on a current quarterly percentage??? Thanks Caz

Graph linked with combo boxes

Dear, I need assistance in plotting a graph which is linked with 3 different combo boxes. I have data for different persons from 1st jan onwards. I have to plot a single graph which is linked with 3 different combo boxes having the drop down list of name, start date and end date. The graph should reflect only the data, once the required person's data for a date range is selected using the 3 different combo boxes. Please assist. Also suggest if there's a better to get this. I could able to link the graph with one combo box earlier using the below link. http://peltierte

Find Duplicate names and delate

Dear experts, I have a small doubt could you clarify that??? That is I find duplicate name but I want to delete one name only, if I filter DUPLICATE….. both names are showing…

Locked for Editing

There is an excel workbook that is locked for editing and it has at this state for over a week. I need to be able to forcibly delete this file, renaming as a different file name is not an option. Is there anyway that I can forcibly delete this file?

Adding a column if two ranges match

A B C D 1 Participant Volume Group 1 Group 2 2 name 1 3 name 3 name4 3 name 2 4 name 5 name 20 4 name 3 1 name 6 name 150 5 name ... --------------------------------------------------------------- Sum Sum I am attempting to add coulmn B based on which group the participants are associated with. I have a master list of the tot

text and number

i have something like this in a cell: T2 T2 E1 T2 N3 can I add just the numbers and put the answer(10) in an adjacent cell and disregard the text?

Pivot Table help

I previously asked about consolidating rows of data that I was looking at and got the following response that worked great: I took your Source data and did the following... Created a pivot Table from the data (I think you are good to here) Placed the Duty Location in the Left Column (not top row) Placed the State to the immediate right of the Location (not in the data section) .... same thing for all of the remaining fields Place FTE's in the data section. Pivot tables like to add in subtotals. You can remove the subtotals by right clicking on the field and select Field Opti

Find and TRansfer from another Tab in same Worksheet

Hi, I have a worksheet in which contact information (names/add/postcode etc) are stored in a secondary tab. I need to update the information onto the first (main) tab. Is there a way I can put a postcode into the postcode column and for it to search the secondary tab, match the postcode there and transfer full contact information to the main sheet? Thanks in advance. David

Looking up your previous questions

I am really in need of looking up a past question I asked here, but cannot find it through the search function. Is there a way to retrieve the messages that you've posted here? Thanks in advance!

Need macro - please help

I have an Excel spreadsheet that is emailed to me each day. I have to make the same changes every time before I print. I am trying to consolidate these steps into a macro but can't seem to get it to work. I shrink the column widths for all columns (the largest of which is about 20 pixels wide). I do this so that when the spreadsheet prints on one page the type is not so small you I can't read it. Then I change the page setup to landscape, legal, and fit 1o 1 page. Is it even possible to make a macro to do this?

Consolidating Data between worksheets that removes dulicates

I am interested in tracking lab values that my staff enter into a daily worksheet. I would like to compile monthly percentages (% low, % in range, % high) but sometimes it is necessary to have duplicate data on consecutive worksheets for my staff's workflow. These duplicate values will cause my percentages (and absolute numbers) to be incorrect if I just sum between the worksheets. Does anyone have a solution? Thank you, Jody

Reduce balance

How can i get the cell with my balance owed to subtract what payment I made on the next cell? -- nat

FORMULA TROUBLE! PLEASE HELP!

Ok, i'm trying to create a formulas to calculate overtime hours for a timesheet. 8 hours starts overtime so I have L11(total hours)-8/24. Now if my total hours are over 8 this works perfect but if there not I get a result of infinate #### and yes my column is wide enough! I have no idea what to do. I'v tried everything from IF statments to conditional formatting, I can't seem to figure this one out. Please help me or give me some ideas as to what to try. Thank you.

Microsoft Excel Merge Cells

Hey Guys, I work for a Marketing company and every week i am inundated with data to present in a clear and concise way to board members. I have cells that are presented like this: 10 11 12 13 14 10 11 12 13 14 10 11 12 13 14 10 11 12 13 14 20 21 22 23 24 20 21 22 23 24 20 21 22 23 24 20 21 22 23 24 So what I have been doing is spending about 2hours a week merging cells. I would highlight the four 10's and merge; highlight the four 11's and merge. I want to know if there is a

Automatically Update Excel Links

I have an Excel spreadsheet that resides in SharePoint. Every time the spreadsheet is opened a message appears asking is links (within the spreadsheet) should be updated. Is there any way; using formulas, VB Code or some other magic :-) to have the spreadsheet automatically update and to have it update every hour (or other time period)? Any help would be greatly appreciated! Thanks in Advance -- Rodman Veney

Help with cell reference

I need help with cell reference in cells. In cells A3:A21 I have a list of store numbers and in cells Y3:Y21 I have scores. In cells D28:D32 I have the top 5 stores scores. I have figured out to get the top 5 scores to populate in cells D28:D32 by using the LARGE function =LARGE($Y$3:$Y$21,1). Now I need the have the stores numbers to populate in cells C28:C32 next to the scores in D28:D32. I have tried several formulas to get this to work with success. VLOOKUP,INDEX/MATCH. I need some help and direction.

filter a list of numbers

I have a list of numbers (20000 to 27583) I only want to see the info for the rows where the number ends with 0 (eg. 20000, 20010, 20020 etc. basically every 10th row) When I custom filter for "ends with" 0, my whole list goes away.

Formula to add up numbers but there are negatives

Hi, I want a formula that will just add up the total numbers and disregard the negatives, is there a true value formula?

Automatic update of links has been disabled - how do I get rid of

I thought I had removed all the links. Does this message when I open up Excel (2003 and 2007) mean that there are still links in the document, or that there were links previously...and now it's just going to show forever. Either way, how do I get rid of it.

Consider space in centering

In centered text, I'd like Excel to consider extra spaces on the left or right. In text consisting of multiple lines, this would allow one line to be forced off-center. But Excel seems to ignore spaces in centering text. Is there any other way to do this - possibly a character that Excel would consider in centering text, but which is invisible on display. (Word can do this using a non-breaking space.) Any suggestions? Thanks.

Excel character limitations

Hi I'm trying to copy between 2 excel spreadsheets, when i do, the end column, which contains more than 255 characters, has the end chopped off. How can i increase the amount of characters that I can copy? Any help would be appreciated. Thanks!

Address of Freezepane

Hi all, In VBA, is it possible to determine the address at which a sheet is locked? I found a property activewindow.splithorizontal and splitvertical but they give me double length integers. Anyone know how toconvert this int an address? Kind regards, Bony -- "There are 10 types of people in this world. Those who understand Binary and those who don''t ..."

Macro to filter dates using Userform1 & printing

I have a speadsheet that has 5 columns. (Headings are in row 2 and are: Cell A2=Date, B2=Name, C2=Paylist, D2=Cycle, E2=Action). Data starts in Row 3 and will go down to row 5000. The dates would start 01-Jan-2011 and could go up to 31-Dec-2011. Right now I have 2 macro's to sort by date and paylist but what I also need is a macro to allow the user to sort by the user inputting a from date (I think I can use a calendar to pick from) and a to date (option of => and =<) in a form. The next piece is how to display and be able to print this filtered info. I am not sure best optio

Folder with largest number

Hello Is it possible for Excel to filter through a set of folders/directories and determine which one has the largest number and then open it? thanks for any insight

Compatibility Question

I have been writing macros and utilizing userforms in Excel to use at work. I am doing this on my personal computer and I am about 95% complete. I was using pre-MS Office 2007. Work also utilizes pre-MS Office 2007. However, I have upgraded both my personal computers to MS Office Enterprise 2007. I am not using any complex macros. Basically, simple calculations, Date & Time commands, and cell references (Range, Offset, etc). I did notice with one of my personal workbooks that the NAME for the cell I used, "APR09", had to be changed to "_APR09" (without quotes), in the 200

access & excel issue

i made a pivot off an access data base but the figures came up showing zero "0", and i founf out that the reason this is so is because the excel pivot is reading the figures as text and not number and i checked the design view everythin is in order. was wondering how i can rectify this.

SUMIF???

I need a formula that will sum up columns N through W but only for rows where column C = specific word AND F = specific word.

Importing Long Numbers as Text cells

I want to import a text file with some long numbers (16 characters and more). Excel automatically converts them to floating point numbers which causes it to lose some digits of precision. When I put quotes around the numbers excel treats it as text but leaves the quotes around the number and removing the quotes causes it to covert to floating point even if the format for the cell is TEXT. If during the import I specify the columns as TEXT everything is fine. However I need to do this for many files and many columns and I need do the process many times on an on going basis. I

Counting of cells with a specific color filled

Hello experts, I have an excel workhseet where different cells are filled with different colors. I need to count no of cells in a specific column with a specific colour filled. For example i need to count how many cells are filled with green color and how many with red etc. What formula i should use? Thanks in advance, Atiq

Deleting Rows - only deletes content

Hello, one of our users has an excel document and would like to delete rows (there are images contained withing some of the cells in each row). When he right clicks on the row header and select's Delete or select's Delete > Delete Sheet Rows in the Cells toolbar, only the content is deleted, not the entire row. we would like to delete the row AND it's contents. Four other users (including myself) are able to perform both functions to achieve desired result, however when this one user delete's, it only delete's the content. I have an appointment with the user to fix in 2.5 h

How to separate background highlight rows in another sheet

How to separate background highlight rows in another sheet

Help Please with If statement / vlookup

How do I write an if statement if I only want to get the averages of the first five cells with a value? I will need to look in about 10 cells, but only avg the FIRST 5 with a value. Some will be blank and Some will be on a different sheet

Time entry in w/sheet

I have a shared w/sheet that requires inputters to make a time entry of time spent on a task. Times can range from a matter of minutes to a couple of hours. I'm Ok with formatting cells to time but what I want to do is ensure that they correctly enter the time as say, 1:20 for 1 hour 20 mins which gives 01:20:00. Using data validation, I can ensure they do not input as 1.2 but when the time is less than an hour, say 25 mins and it is wrongly entered .25 or 0.25 it does not prompt the inputter re incorrect input (0:25) and the entry becomes 06:00:00. Assistance would be much

Collect data from spesific cell in multiple sheets

How can I collect data from cell A1 on sheet 01.01 thru 31.12 (Dates) to summary sheet? I've tried fill and copy formula with different use of ! and $ but I've not been able to solve this by my self. Thank you

Can I read a range of scenario (input) values from a table?

When creating several scenarios (to ultimately get a scenario summary), it's laborious typing in a scenario name followed by a scenario value for each scenario. Is there any way of setting up a table of (names and) input values and just reading them into the scenario manager?

calendar

Is it possible drop down the calendar when click the specified cell That help to select dd/mm/yyyy then the calendar will hide

Primary and Secondary tech locator

Hi, I use a 3rd party excel plug in called Spheresoft that I use to calculate distance in zip codes. My question is really a function of excel and not the tool itself. In short I have in Sheet1 a list of sites: address, city, state, zip etc. I have a sheet called techs that list all the name and addresses of my techs. Basically it looks at the zip code from sheet one and picks the one with the lowest distance value. Works great. However.. It would be great if i could have column c be the second closest tech. Is there a way to have it exclude the tech from column b (which is the

Excel

I have a price list done in Excel and I want to increase all prices by 5 or10%. I know there's an easy way to do this but I can't remember how to do it. Can someone please help.

Cannot copy & past beween workbooks

Hi, I have two workbooks open in the same Excel instance, but cannot copy and paste. The paste and paste special option is grayed out in the second workbook. Thank you for your help.

VLookup Function over Multiple Worksheets

I am trying to use the VLOOKUP function over multiple worksheets, can this be done on Excel 2003? I am trying to automatically retrieve data that is dependent on previously entered fields in drop down lists that I have created. Regards,

How do i find my post from a few weeks ago

How do i find my post from a few weeks ago?

Notification to my email address

I have set up my profile to receive notifications via email. I believe that it is set up properly and I performed the verification steps and received positive response. Still I am not getting any notifications. What can I do to start getting notifications? Who can I contact? Tom

Conditional Comment using Cell value as part of it

What I'm trying to do is the following: if cell(a1) is different from 0(zero) then, cell(b1) should have a comment that say, the value of cell(c1) is the payment, next line the value of cell(a1) was refund, next line Total for today = cell(c1)-cell(a1) Example a1 = $10.00 c1 = $30.00 B1 (comment): $30.00 is the payment (c1) $10.00 was refund (a1) Total for today: $20.00 (c1-a1) can anyone help me on that? thanks in advance

Updating Excel Spreadsheet

I have 3 users that use the same spreadsheet, is there a way of automatically updating the spreadsheet of one user with newer information input by another user.

Insert row(s) with vba

I'd appreciate some help to determine if I'm attempting the impossible... We have a workbook to generate proposals. Each proposal contains numerous sections. Each section has many line items. The first item in section 1 is numbered 01-001, the next 01-002 etc. The 01 is the section number, the 001 is the item number. Iuse the formula:- =CONCATENATE((TEXT($A$2,"00")),"-",(TEXT((RIGHT(OFFSET(A5,-1,0),3)+1),"000"))) to automatically generate the item number row by row. The value in $A$2 is the section number. This way I can use vba to insert a row and the numbers look after themsel

Ranking Top 5 in score and percentage

I have read many postings on ranking and they don't seem to make sense to me, that is why I supppose I am here. :) I need a formula that will sort store rankings based on the highest average score and the highest plus "plus/minus score". Here is some of the information: Column A3:A21 is the store numbers Cloumn X3:X21 is last week average (percentages) Column Y3:Y21 is this week average (percentages) Column Z3:Z21 is plus or minus vs last week average (percentages) Now in column C28, which is rank 1, I want the store number (A3:A21) to show up in C28 based on it having the Hig

number format

I have a large column of numbers, they all need to be 10 digits long. If they are less than 10 digits I need to proceed the number with zero's until each number is 10 digits. 3418 3909867750 3916717360 21972 9064130 4106431176 3919306948 9092768 24976 28241 3914169069 539 7187 29132 3919530745 3908063591 22210 3911589814 28357 3915302636 -- Randy

Get #### when typing

When typing a lengthy statement in a cell I get ######. Is there a character limitation in Excel 2007 and is there a work around to this? Thank you Bill

Matching records in two lists

I have a list of part numbers in one range (list) on a worksheet with the description in another columns. In a seprate range (list) on the same worksheet, I want to see if there are any matches in the part number column. How is this done?