Excel Forum
-
Values Lookup in excel Solved/Closed
Hello, i want to match sheet2 with sheet1 WHERE sheet1 is the master sheet and has all columns. sheet2 has only two columns as in below demonstrat...
-
EXCEL 97 if then Solved/Closed
Hello, I would like a Cell "1" to look at two Cells, Cell "2" and Cell "3" and depending on the answer enter a positive or negative vaue of Cell "4...
-
Excel / after print +1 Solved/Closed
Hello, My name is David (form Slovakia)! I would like to ask you for help with the folowing situation to solve: I need to prepear one document wh...
-
Excel - dependant copying / summary sheet Closed
Hello, I want to set up a monthly sheet that records items in a table, first columm of table (A1) is headed completed, B1 is Date, C1 is item then fo...
-
Excel Closed
Hello, I need to colour code one cell as a result of many for a risk assessment thus if the multiple cells equate to less than a figure, a certa...
-
EXCEL 2007 NO VALUE= NO COLOR Solved/Closed
Hello, I've conditionally formated multiple cells to highlight green when the inputted date is within a 2 year period and red if it exceeds 2 years...
-
comparing cells and in multiple columns Solved/Closed
Hello, I have two columns A and B A has items that have been priced B has items price (no dollar sign) Is it possible to have a macro go down co...
-
Update two different spreadsheets from one ma Closed
Hello, I need to update two completely different spreadsheets from one master spreadsheet in Excel. How do I accomplish this? Please help. Thanx i...
-
Excel Macro-Highlight if difference > or < 2 Solved/Closed
Hello, I need help writing an Accounting excel macro I am working on. It appears that everything is working fine, except for one part I need some h...
-
sum the values 100s sheet in a sheet Closed
Hello, i want to know to apply the formula to sum 100 sheets in one sheet
-
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...
