Excel Forum
-
Excel "IF" formula problem Solved/Closed
Hello, I have a row of 4 cells each containing an "if formula" to get information from another worksheet. An example of the formula in these cells i...
-
Figuring percentages in Excel Solved/Closed
Hello, we are doing a weight loss contest and trying to figure out a formula to do the math. We need a formula that will figure the cumulative pounds...
-
extract top 10 records from a sheet Closed
Hello, actually i have a sheet where no. of records, i want to sort top 10 or 50 records from it on another sheet, if i have changed the original rec...
-
Excel question Closed
Hello, I am trying to create a form based on the last row of information on a separate worksheet. I would like for this form to automatically update...
-
Marco help! One macro for multiple row tasks Solved/Closed
Hello, I have two separate workbooks that I need to compare. Task at hand is I have to find specific text in workbook 2 (col A) and once found - ...
-
excel formula drag Closed
Hello, ok i need to drag a formula down however i want one value in the formula to change one one not to. for example: c1=a1+b1 c2=a2+b1 c3=a3...
-
unique text formula question in excel Solved/Closed
Hello, I have 2 columns of names in columns a & b and a list of dates in column c. Column A has a unique name in each cell. Column B had the same 5 o...
-
update dates in excel spreadsheet each year Solved/Closed
Hello, i have 4 spreadsheets linked together which i use to keep track of my accounts. all 4 spreadsheets are in one folder. On each spreadshee...
-
Comparing data in two columns for matches Closed
Hello, I am lookin for a formula that can compare two columns of data to see if they match. For example: A B C 1 3 NO 5 5...
-
To add row after 24 rows and get the sum Solved/Closed
Hello, I have hourly data of one year in rows without any break. I want to add row after 24 hrs and get the sum of all the coumns in that row. In oth...
-
changing default date format in excell Closed
Hello, how to change the default date format. I have year/month/date as default and I want to change this to day/month/year
-
comparesion two two work sheet Closed
Hello, I am trying to find an easy way to compare and extract data from two excel worksheets
-
Please help mo to solve my problem in excel Closed
Iwant to get the total of this column B-----C ACFT CHECK TVP B777 A B747 B B777 A B777 A B777 A B747 B B747 A i want to get the total of B...
-
Conditional Formatting in Excel Closed
Hello, I am trying to incorporate a little checker into my spreadsheet. I basically have a table of numbers and I would like them to be coloured...
-
problem with browsers Closed
Hello, my friends i have problem with my laptop since a week ago i am not able to open some websites and some games in facebook is it the browsers p...
-
Excel - if then statements Closed
Hello, I have 8 columns total and want to create a if then statement for the sum of column D IF in column A contain a + for that row. Almost lik...
-
Excel Search and Copy macro Closed
Hello, I have a large spreadsheet generated by Blast, a program for determining similarity of genetic sequences. I am interested in copying out on...
-
help!!!! excel is driving me nuts Closed
Hello World, i will make this short. i am trying to transfer data from one sheet to the next in the same work book. however all the originally dat...
-
Problems with the filters excel 2007 Closed
Hello, I have a excel file with one object (PDF file) for each row (>200 rows), but when I create a filter the object files don't move to the co...
-
cant add flash player in browser Closed
Hello, I have installed the adobe flash player but it does not show it in browser. Though i have installed it, whenever i used to play the video ...
-
free browsing Closed
Hello, i have the nokia 3110c with idea i want to browse free internet in my mobile can you suggest any way to do this
-
associating two different cells Closed
Hello, I am trying to find a formula that will allow me to associate two different columns. Example Sheet1 A B Jim 5 Bob 3 Jim 2 On another sh...
-
I need VBA help please!!! Closed
Hello, I need help trying to write a vba code that will look at a column of data and see weather if the cell is red or green, and in a column of data...
-
compare two columns and return text string Closed
Hello, Does anyone know how to write a formula in excel which compares column A to column C, sees if the numbers in these two columns are the same...
-
ExcelVBA-In a column, change only cells that Closed
Hello, In Excel VBA, In a column, I want to change only cells that has only one character and add a "0" (zero) prefix. for example if column C c...
-
microsoft excel 2003 column and row missing Closed
Hello, Am using microsoft excel 2003, and when am opeing excel it is showing only blank sheet, no colum and rows are appearing, please let me ...
-
Excel - adding +8 on a button click Closed
Hello, How do write a macro for adding a specific number to different cell on a button click. Each Click adds 8 to cell I30 Within the sheet your in....
-
delete all rows except first and last row Solved/Closed
Hello, I have an excel file, I need to delete all rows in this file except for the first and second row. First Row = header row last row = contai...
-
Excel 2003 VBA code for filtering Closed
Hello, I need to perform an Autofilter function in Excel 2003 that allows me to filter a list using the contents of another cell as the criteria. F...
-
EXCEL Closed
Hello, I'm constructing a spreadsheet as a monthly staff workrecord. Column A reflects the date the work request was received. The worksh...
-
i cant open my office 2003 (word,excel,etc) Closed
Hello, im a new user of windows 7.. im using office 2003 for my school homework.. but it seems its not compatible to my system... i wonder what s...
-
Excell problem Closed
Hello, How do you add cell values if they identical reference cells by using VLOOKUP. Employee Supervsior Cust Handled ...
-
unable to open youtube with any browser Closed
Hello, For last two weeks I'm unable to open youtube, all the other websites are working fine except this. please guide me if any of you have suggest...
-
unrecogrized file format in MS-excel Closed
Hello, i m ff, i need help in ms-office 2003, i installed an antivirus, but now my ms-office files (ms-excel) r not opening, it gives me message that...
-
Excel 2003 Conditional formatting help Closed
Hello, trying to highlight a date that is 5days old, than a differnt color for 10 days old and a different color for 15 days old. For instance, ...
-
Paste table from one worksheet to another Closed
Hello, I'm looking for a macro (or a formula- whichever is easier) that will copy and paste a range of cells from one worksheet to another based on a...
-
return data from one spreadsheet to another Closed
Hello, I have a workbook with 3 spreadsheets. Spreadsheet 1 is for data entry. The spreadsheet has 3 columns, Description, Income, Expenses. O...
-
excell calculations Closed
Hello, I am a programmer and not use to restrictions when calculating formulas. I would like to know if there is a way to calculate a number and plac...
-
to know about to sppeed browsing and download Closed
Hello, i have problem in browsing and downloading. the speed is so slow.so what is the solution for that?
-
excel formula Closed
Hello, I have a excel data file called BOQ. in which i have around 2000 line items in it. and many are repeating in many areas it is like a furniture...
-
Help in Excel data comparison Closed
Hello, i need to find a solution to my problems. Can anyone help me ? 1.Data in column A of a worksheet are compared with Data A of another worksh...
-
excel column comparison Closed
Hello, I am trying to compare severalcolumns in excel which have very large data sets- eg. column A & B- (A1:A3000) and (B1:B380). I want to find ou...
-
Excel Help Solved/Closed
Dear All, I really need your support with my issue: I have around 70 tasks in Sheet1 some of them done with 100% (according to other numbers in th...
-
Transferring data between tabs in excel Closed
Hello, I need to transfer data between sheet tabs to only take certain information to the second tab is there a formula or a procedure that I need ...
-
i cant access my wap browser Closed
hi i cant access into my wap browser it always says "connection failed"
-
VBA Code that will find, copy and transpose Solved/Closed
Hello, I'm looking all around for a VBA code that will: 1 - Search down one column for the word "ADDRESS" 2 - Once "ADDRESS" is found, I need t...
-
Excel Formula Help Closed
Hello, I have two columns - one can have 1 or blank (so I can SUM the 1s). The other has an H or A . I need a formula that will look in each col...
-
Excel Formula, or Macro Closed
Hello, i need a formula or a macro for Excel 2003 that will do the following: i have a list of logins in column B, lets just say 1,2,3,4,5 going ...
-
Browser for g'five u800 Closed
Hello, I am deepak i am useing g'five u800 phone. It is having wap browser. can i load any browser for accessing internet.it having no built in ...
-
Unable to browse free wth my pc Closed
Hello, pls send free browsing for my pc and using nokia e65 with mtn