Excel Forum
-
number to word in excel Closed
Hello, How to convert a numeric value into English words in Excel plz show that formula Configuration: Windows XP
-
match with conditional format in excel 2003 Solved/Closed
Hello Internet, I am in a bind here as I have exhausted my excel knowledge on this problem. I am looking for a way to highlight (in red) a cell wh...
-
Excel 2007: Reading data from sheet to sheet Solved/Closed
I am trying to read data from sheet "a" cell to cell on sheet "b". I entered function "=sum('sheeta'!f20) in destination cell, but all I am getting ...
-
Excel Formulas Closed
I need a formula that will allow me too add the number of red cells. Can anyone help please Configuration: Mac OS X / Safari 525.13
-
Excel Closed
I am working on a balance sheet i want a macro that can adjust the difference between assets and liabilities by increasing long term debt and i want i...
-
web sheet design Closed
Can I build a spread sheet in excel with several columns of information and import that to a web page? I have no experience building web pages but I k...
-
Excel Formula Closed
Hello, I am a total beginner at Excel and I (really) need a formula... If you could (please) give me the formula for this, I could alter it myself to...
-
Import web data into Excel Closed
Hello, I'm currently importing stock data into a spread sheet, and it works pretty well. What I would like the "update All" button to do is automatica...
-
Excel VLOOKUP Macro Solved/Closed
Hello, I am working on a project to create a simple VLOOKUP. I have created the macro and it works well, but now I am looking for some advise on ...
-
CONCATENATE multiple rows into one row excel Closed
Please need help in macro, I have thousands of data from .txt to .xls. Example of data value Description gem-967869 C...
-
Excel '03 Data Filter puzzle Closed
I'm using Excel '03 and I have two columns with data, A & B. Column A holds the name of a letter and Column B stores the body of the letter. When ...
-
internet connected but not able to browse Closed
Hello, Windows XP Desktop is showing that its connected to the internet, but when I try to open internet explorer it says. Cannot Find Server. Page ca...
-
can connect internet but not to browse Closed
Hello, Windows XP Desktop is showing that its connected to the internet, but when I try to open internet explorer it says. Cannot Find Server. Page ca...
-
Interesting Question For Excel Champions Solved/Closed
Hello, Interesting Question Guys: Suppose Sheet 1 Is "Data" Sheet And There Are Too Many Rows... Like A3 Is S.No B3 Is Supplier Name C3 I...
-
coping rank for whole dataset in excel Solved/Closed
Hi i want to work out the ranks for my whole data set, if i type in the formula for the first line then drag it for the rest instead of working out ...
-
Automation of running excel macros Solved/Closed
Hello, I have a macro in excel which needs to be run once a day and i dont even want to open the excel sheet. How can i make this process automatic...
-
Macro: Group ColA with ColB results Closed
Im trying to build a macro to produce the expected results below. I have duplicate tests in ColA with associated data in ColB: I need to merge the...
-
Browser Not Connecting Closed
My computer connects to the internet and Windows update works. Only firefox & IE8 cannot connect to a website. I turned off the firewall but that did ...
-
Drop down boxes in excel 07 Closed
Dear All, I have two columns A & B which i wish to turn into two drop down boxes, the first drop down box i wish to search column B for 1 of 4 allo...
-
copy data to excel below existing data Closed
Hi, I want to copy the data from some other source to the excel. The copied data should get pasted few rows below the existing data. Configurati...
-
how to copy a row to another worksheet Closed
In am maintaining a file in Excel 2007 in which I would like to copy rows containing specific data in a particular column from a master worksheet to a...
-
how to align all common list in excel? Solved/Closed
i have 4 columns. the first two (A & B) columns are list of cheques i issued. then the other two (C & D) columns are list of cheques encashed from Ban...
-
Macro to find/replace in notepad Closed
I am in need of editing a text file in notepad that was created via a macro in excel. I have created the code to open the file in notepad but was won...
-
Create lists of columns containing a value Closed
I have a need to populate a column in one sheet with column headings from another sheet that contain a given value. I will illustrate better below. ...
-
Browser not loading pages Closed
I don't know if my Firewall is totally misconfigured or if the antivirus program that I have on my PC (Win 7) is keeping me from loading webpages. If ...
-
Coping Cells With A Loop Solved/Closed
Hello, I am stumped on what should be a very simple macro. I am running a macro that is using a look-up table to compare the values in column G. ...
-
freebrowsing on mtn zain both GSM and laptop Closed
pls guys get me free browsing on dis network mtn and zain both on phone and laptop send it here email kwada90@yahoo.com
-
Lookup a header in a table - Excel 2003 Closed
So HLOOKUP doesn't seem to work as well as I hoped on this one, I would like to return the text on the top of a table column by first finding some...
-
comebiine multiple cells displays formula Closed
Configuration: Windows XP / Firefox 3.0.18 In Excel 2007 Very basic formula but I think it is a bug. A1 has first name; B1 has last name; C1 has ...
-
Excel copy not working Closed
Hey, I got a code from this site and made changes to copy from a different excel file and paste to another file. I'm copying from a file Source.xls...
-
Using Excel Macro to insert jpeg from dir Closed
Hello, Please help. I have written a macro to pickup jpeg file from the directory and insert it into excel. I have issue with picking up jpeg ...
-
MS Excel issues :/ Closed
I need to replace a range of 7 cells with a choice of another several ranges, based on the valueof (yet) another cell. For example: Range a1:a7 val...
-
copying of data from one excel file to other Closed
Hello, I have a excel file which is having the list of filenames (eg- MEF_collection) in B column. Now i wanna open another excel file which ...
-
Lost my Huawei driver mini CD and the browsi Closed
I have lost my Driver CD for the modem supplied along with modem so please download the same for installin once again on my laptop after formating it,...
-
Help on Excel Formula Solved/Closed
I need to create a formula to give me with value and not TRUE/FALSE information. I did use the IF function, but it results in TRUE/FALSE and I need a...
-
Excel file not open in Spice QT66 Closed
I have Spice QT66 model. i try to open xls. file in phone but not support phone. can tell how i can view this file. Configuration: Windows Vist...
-
I need to consolidate multiple columns- macro Closed
I am trying to write a macro so that I can combine data from several worksheets, the data is contained in different columns in each worksheet but eac...
-
Comparing text lists in Excel Closed
I need to compare a text list in Excel in Column A in Sheet #1 to a text list in Column C in Sheet #2 and then print the resulting text it found in Co...
-
Excel Data Copy Closed
I am looking for a formula that does the following: Looks at cell values in a particular column If the cells have data it then copies that data to a...
-
create macro to copy data from rawdata file b Closed
Hi experts... Need a help from you to create an macro to copy the data from rawdata file by condition and paste it into another summary excell file. ...
-
critical macro to copy from rawdata to summar Closed
dear all, I need your kind help to create an critical macro in which i have 2 files, 1. rawdata in which i need to filter for certain conditions ...
-
help cant brows microsft webpage Closed
hi i run 2003 server and for sum resone i cant acces microsoft webpage but i can brows all other webpages on the net can annyone help me Configura...
-
Excel function as a quoted cell number Closed
Hi, I want to have a formula for the number of the row I am quoting, i.e. B[=4+4*A7], but it does not work Thank you! Elena
-
excel Closed
Hello, I have a 3 columns say A, B and C.. Column A has say 140 names and Column B and C have 256 names as B and C are dependent on each other. ...
-
VBA code to send a mail Closed
Hello, guys, im looking for a VBA code to write that so when i click upon a command button it will populate a pre ready email with a fixed list of...
-
no browser opening,internet connection presen Closed
Hi, I m not able to open IE or mozilla to connect internet, though I have internet connection, bcz the messengers are working fine. Please Help....
-
Identify two or more are same or not in Excel Solved/Closed
Hi Everyone, I have an excel formula question that someone might can help me with. A B 1
-
I need a macro created for the example HELP!! Closed
Hello, I have a two columns A and B as listed below: A B C Location Phone CHENNAI 4458720241 CHENNAI...
-
Copy a range of cells to another worksheet Closed
Hi, I have a workbook containing multiple worksheets. I enter data manually in all the worksheets except one say worksheet "X". My requirement is to p...
-
Excel: Convert rows to columns and sort by ID Closed
Hi, I have an Excel sheet with the data in this order: A B C D date1 / text1 / amount1 / ID1 date2 / text2 / am...