Excel Forum
-
Calculating exact percentages in excel [Solved/Closed]
Hello, I'm trying to add exact percentages like 99.54%, 84.23% in six cells then calculate the average. I've tried =AVERAGE(A1:B1:C1) but it only ...
-
Excel Nested Formula [Closed]
Hello, I want to use a nested function to locate and flag data in a separate cell. I currently use a complex formula such as in G6 and down (...
-
excel macro to do calculations on csv files [Closed]
Hi, I have multiple comma delimited text files that are generated from an analytical instrument. What I want to do is be: (1) Able to select ...
-
INTERNET BROWSING [Closed]
Hello, Am having a problem when it comes on browsing the internet using my NDKLA n97, am unable to to access hotmail and other useful sites to me,ac...
-
EXCEL: Partial Cell matches in dfrnt sheets [Solved/Closed]
Hello, I searched a lot and found quite some useful results about searching Partial Cell matches. But if the cells belong to different sheets how ...
-
Excel: Auto fill cells in various locations [Closed]
Hello, I'm working on an excel worksheet where I have 2 spreadsheets running. On one of them I have a list transactions with different categories ...
-
How record macro?, it play all action slowly [Closed]
Hello, I have tried so many times but could not do. So give me some tips to record new macro and it does play all actions slowly when click on run m...
-
VB SCRIPT FOR COMPARING EXCEL FILES [Closed]
Hello, i need a vb script code to compare two excel files, eg. file1.xls and file2.xls has to be compared using vb script....please help me...
-
bring a cellvalue from sheet2 to sheet1 [Closed]
Hello, I need to find the department number on sheet2 based on the list on sheet1 and then once that is matched bring the total cost that will be ...
-
Excel delete duplicate rows [Closed]
trying to delete all rows that are the same leaving in the excel only the rows that are unique ex: heading 1 heading 2 heading 3...
-
macro to copy info from one column to another [Closed]
Hello, I have a tough macro to figure out! There are 3 parts to it. Here is what I have: I have an excel worksheet that is currently filtered...
-
Macro to invert sign [Closed]
Hello, I need a macro that will flip a positive to a negative and vice verse. I had the following but it stopped working all of a sudden... Di...
-
Excell 2007 multiple pasting [Closed]
Hello, In Excell, I want to copy the same line several times within the document making slight changes after pasting each line. A change made in th...
-
Please help - run macro when switching sheets [Solved/Closed]
Hello, If someone could tell me how to run a macro upon switching worksheets, that would be extremely helpful. If this is not possible, perhaps ru...
-
undoing a macro to retrieve info back [Solved/Closed]
Hello, If I accidentally run a macro, can I (edit undo) to retrieve the information back to how it was? Configuration: Windows XP / Internet Ex...
-
macro to blank out filtered columns [Solved/Closed]
Hello, I have a worksheet that is filtered by a number. I would like to blank out columns M, N, S and T. (Only the filtered information) Can yo...
-
excel conditional formatting [Solved/Closed]
Hello, if date in cell A1 appears anywhere from B1:B30 then apply format. Configuration: Windows XP / Internet Explorer 7.0
-
Macro to get the colour of a particular cell [Closed]
Hello, I hope somebody can assist me with this. I wanted a macro which identifies the colour of the cell and displays the colour in a notepad for...
-
How I can count date in excel? [Closed]
Hello, If I have list of the dates, how I can count the dates that pass today? Configuration: Windows XP / Safari 533.4
-
Run a macro when modifying a cell [Closed]
Hello Guys, Maybe you can help me with this one, I am trying to run a macro when a cell changes value, the code im using is the following: Priva...
-
Code to open a tabs from combox excel [Solved/Closed]
Hello, I'm looking for a code, i can put in a combo box to show up different tabs located in my spreasheet. example: I have four tabs called tab1,...
-
copying and pasting certain cells [Closed]
Hello, Configuration: Mac OS X / Safari 531.22.7 I need to transfer (copy and paste) certain information from Column A of one tab (Tab 2) t...
-
Excel help [Closed]
Hello, I have an excel spreadsheet which I used to keep track of some records. A sample as below: ColumnA ColumnB Row1 07/09/09 ...
-
Excel List [Closed]
Hello, If i have a list of one thing in column A and list of another in column B, Can i get a full list of any column in another sheet with some f...
-
Excel 2007 days and dates issue? [Solved/Closed]
Hello, I was working to have the week numbers in excel and i step into a question when i entered in cell "B1" the date 05/1/2010 and i changed the...
-
Excel help! [Closed]
Hi. I have a formula that relies on a series of monthly updates all being populated before it will produce an outcome. What this means is that even if...
-
how to delete web script in my excel sheet [Closed]
how to delete web script in my excel sheet. i select the web script picture, and press delete & Cut options is not working.
-
Internet connecting but can't browse [Closed]
Hello, My computer was running kinda slow so I decided to run an antispyware program. It's called "SUPERantispyware" and I ran a scan and it claimed m...
-
Moving from cell to cell using arrows [Closed]
Hello, I am using Excel 2003. I am trying to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. It...
-
Excel formuls [Closed]
Hello, I have a cell which contains number and alphabets and also some characters. Is there a way to just get alphabets out of it
-
Find similar town names in Excel [Closed]
Hello, I have a list of towns in Massachusetts. I want to combine similar towns into one entry, so for instance, Brookline and Brookline Villa...
-
Excel formula [Closed]
Hello, Configuration: Windows Vista / Internet Explorer 8.0 Dear sir, I need a formula, if the cell contain a prescribed text and the c...
-
Excel Formula [Solved/Closed]
Hello, I am looking for a formula or script that can help me with the following. I am doing a spreadsheet for 19 different offices (on seperate...
-
Excel Sheet Counter [Closed]
Hello, I want to count days, exclude Sat.and Sun and Stat. holidays and have the program tell me the date 20 days, 40 days down the line. eg. I p...
-
Formula for Excel [Closed]
Hello, If I need to look at a cell and if its > than 5 than I need to add 1 unit to another cell. Each additional 5 means 1 more unit in that col...
-
Matching columns [Solved/Closed]
Hello, I have to an issue with matching columns. Column A Column B Column C Column D Column A: This has 300 lines with account #'s Column...
-
Excel Question about linking workbooks [Closed]
Hello, I am having a hard time figuring out how to link workbooks. I would like to have a main workbook that we number with a job number and a row...
-
merge data from two sheets [Closed]
Hello, Hi, I have two sheets with different data, but one colum is the same (customer name) so I want to add the data from sheet 2 into sheet 1 so...
-
EXCEL [Closed]
CAN I ABLE TO ACCESS A TEXT ON FIRST TO SECOND WORKSHEET IF I ENTER DATA IN FIRST SHEET IT CAN BE RETURN IN ANOTHER FILE ALSO
-
Create worksheets with links from a list [Closed]
Hello I have a list in excel and for each entry in the list I would like to create a new worksheet with a link from the original list. Is this possibl...
-
Excel 2007 VBA: Copy pivot table [Closed]
Hello, I want to copy the numbers (numbers only) in a pivot table to another worksheet by using VBA. The following code works if I use debug mode...
-
Office 2007 excell wont open excel 2003 docum [Closed]
Hello, Please help me this is could cost me my job! I got a new computer wirh win 7 and put office 2007 on it. I had files back in excel that 2003 ...
-
excel forumlas [Closed]
Hello, I have a column that contains "yes" or "no". I need to total the "yes" in each column. What is the formula to do this? Thanks
-
need a macro for the following [Closed]
Hello, i am have a set of numbers( indicating the product serial number) in rows having comments which include some text + date of manufacturing...
-
macro that takes multiple csv files and puts [Solved/Closed]
Hello, I need a macro that takes multiple csv files and puts them all in 1 worksheet. The csv files all have header info that i do not want copied ...
-
Excel 2007 "If....Then select Row and move&qu [Solved/Closed]
Hi all! I have what would appear to be a basic question, but can't seem to put my brain around the solution. I have a spreadsheet on Sheet 1. O...
-
Comparing 2 spreadsheets [Closed]
Hello, I need to compare 2 spreadsheets that are coming form different sources but have mainly the same content. I can easily edit them so that t...
-
Excel macro to find value with a condition [Closed]
Hello, Say, a code like C1180230 may occur more than once in column A, but its occurence with name "Recipe" in the previous cell is unique. I wan...
-
Excel function query [Closed]
Hello, I want your help for calculating the balnk cell in the row in a particaular cell and paste the top row column value in that cell. Means ...
-
Macro for copy pasting [Closed]
Hello team , 1.Can you please help me with the macro to copy paste the filter area to another work sheet . 2.Also the tab from which it is copyi...
