The discussions
Add cells with other identical attributes
SolvedI'm looking to create a formula which can be copied into other cells that will add numbers in one column, where their attributes in another column are...
Line to reflect a dash if no value
SolvedI am designing a check book registry, and I want the total column to reflect a - if there is no value from the formula. I had it this way in the past...
Help with excel data selection
SolvedI would like to take a worksheet and create new worksheets for each specific value in a column. for example, one of my columns is "customer". I want...
Excel 2007 vba find last
SolvedI have a mutipage workbook where I am coping information from three sheets and consolidating the information to another sheet so I can export into a c...
Macro to find a info in more than one column
SolvedHi, I need a help to match values in a column from other two columns. I have two columns with some values on them. I have another column [t...
Zeor to the end of 4 digit number
SolvedHello, Can someone tell me a formula or macro that will add a 0 Zero to the end of a 4 digit number in each cell. I get a excell file with the 4 di...
Excel frame a do while loop or macro
SolvedHi All, Could anyone help me to frame a Do While Loop or a suitable macro? I need a method to copy formulas present in Cells F10 to Q10 in She...
Date formate
SolvedConfiguration: Windows XP / Internet Explorer 8.0 hi i have date formate in dd\mm\yyyy & dd-mm-yyyy. i need all the dates in same formate exp. ...
Formula for dropdown list
SolvedConfiguration: Windows XP / Safari 532.5 n excel i want to use a drop lown list and when enter specified text, then next cell should display my spe...
Problem in date format
SolvedHi EVERY one I have very Big Problem i am making one report where two type of date format is appearing like MM-DD-YY 03-08-2010 and DD--...
I want the installation cd key of cod 5
Solvedi have the cd and i have lost the cd-cover and also lost the installation code,please help me.
Insert rows with data when criteria is met
SolvedHi, Thanks in advance for your help. I have two tables. If a field in table A is chosen, I want a macro which will insert rows of the data listed ...
Input a range of cells
SolvedIf i want to highlight a row of cells in red to show a lead is dead say A1 to E1, buy inputting "lose" in E1 I now have the formula =$A$1="lose" whi...
Copy data next to a cell and paste it below
SolvedHi, everyone I am a newbie in here, and I hope some one can help me solve this: I having a data such as the following cell | A ...
Macro assistance
SolvedI have a spreadsheet that has data ranging from C3:C263. Workbook is 'GSU CAS Transactional Upload', Sheet is called 'Alliance Upload' I need to...
Convert a date figure into word in excel
Solved/ClosedI want to know the formula, how can I convert a date figure into word in excel 2003
Excel macro to repeat and insert rows
SolvedI am trying to write a macro that will insert rows as follows: Col 1 Col2 Col3 1 S 456 2 A 222 3 M ...
Link question
SolvedUsing Excel 2003 - I have two tabs one has detail info for unit cost; the second has summery info for each unit. What I'd like to do is if you are on ...
Macro for array vlookup to worksheet
SolvedLooking for help with a quick macro please. I have four tabs in the workbook: Datadump - contains daily raw data to clean Central - Accou...
Need help with excel message pop up
SolvedI need Excel VB help to show a message pop up box to display whenever the value is below 10 or greater then 50 that's also not a multiple of 5 Con...
Updating data in two+ worksheets
SolvedI have a question, I just created a spreadsheet with 8 tables which contain a deferent data and with Autosum column on each table and I created als...
Conditional formatting with 3 cell
SolvedHi all I want to do conditional formatting a cell but based on the criteria set by 2 other sells in the row so if A1 = 0 and B1 > 0 i want C1...
Link data
SolvedDear Excel Expert, I need help. I need to manage my data with diffrent User different sheet & the data need to update every week in master sheet...
Range change colour
SolvedPlease help. If I have a range of Data in cells say A1 to E1 and I wish to change all to red when I enter the word "lose" in A1 only what do I need...
Extract date from a series of numbers
SolvedHi, I need to extract date from a series of numbers like 250420102356478 where 25(date)04(month)2010(year)2056478(sequence number) and answer sh...
Pls help me with excel formula!
SolvedDear excel experts, I have a dataset of A1:A15. I want to make a formula stating that if 10 cells of the range A1:A15 are greater than or equal 2 ...
Finding the last row dynamically
SolvedHi, I am using VBA in Excel 2007. I have a worksheet which has multiple columns. Each column has different number of rows. I want to find the la...
Date formatting problem
SolvedI have a date in a cell that is 23/10/2008, and shows up as this in the editing bar, but in the cell address it shows a figure, ie 39744. Why is this ...
Vlookup formula
SolvedHi, Could you please anyone help me in this? (column headings : Roll No. , correction date , Type , code , rank , Marks , exam date , time ,...
Highlight a cell greater than the one above
SolvedHello, I am trying to use conditional formatting to highlight cells in a column (formatted as a table) that are greater than the number in the cell...
Xcel formula needed to return multiplication
SolvedI need a formula that does the following: if b10 is => than 10.03 AND c10 is => than 6.69, then multiply b10 times 328 It seems simple, but I ...
Incentive calculation with few condition
SolvedHi, I need help... each month I need to calculate the incentive. manual calculation is wasting my time. i know excel can do it, but I am not ...
Product key
Solved/ClosedHello, I've trying to enter the product key so many times as behind my laptop. my lap is very new. i can't work with any software without this produc...
Sorting and deleting redundant value
SolvedHi, I have been trying to sort our patient data in our daily work-up in the lab as below: "sample external no" "barcode" "assay" 4 321456 amf ...
Conditional formatting
Solvedcan any one help me i have following situation and i drag the formula down , i do not want to show the result in c2 because there are no data in it(b...
Excel formula!
SolvedI would like to make an excel formula that if at least 7 out of 10 cell (i.e A1 to A10) are greater than 5, then return as " accepted", otherwise "...
Selecting the required cells info from the co
SolvedHi, I have a data like below in one column in excel: SL#00000 Product: ABC Region Name: Name1 City :1 Country:1 User con: Id type SL#88888...
Conversion of values already present in cells
SolvedHi: I need to convert values already present in a range of cells to another currency. The current range changing causing headache. Any suggestions...
Copy paste - excel
SolvedHi I have a spreadsheet with a list of job titles in column A. there are a list of dates in columns G & I. there is information in all the ro...
Selecting a printer in an excel 2007 userform
SolvedI am using the following code: Private Sub CommandButton1_Click() Application.Dialogs(xlDialogPrint).Show UserForm1.PrintForm End Sub I can...
Excel 2007 - change cell color using if
SolvedI have a cell with a % in it. I would like that cell color to change to red if the percentage is below 60%, and change to yellow if it is between 60% ...
Lookup data on different worksheets
SolvedI have 2 spreadsheets with the same town names in column A and different dates in column N. I have a third spreadsheet with the town name and have ...
Excel find a value <>2#'s &get a value beside
Solved/ClosedHi All, I want to enter a number in cell A1 (Sheet 1) and have a formula which gets excel to go to sheet 2 column A finds the two numbers the e...
Excel formula for finding percentage of
Solved/ClosedHello, I need a simple formaul for finding the percentage of Total number of members: answer in column A392 Total number of members who have prov...
Unlock memory card password
Solvedhey i forgot my memory card password n cudnt find ny file manager optin in my nikia 7210.pls help!!! Configuration: Windows 7 / Internet Explorer 8.0
If statement thats adds
SolvedDear All, I would like to create an If statement which returns a 1 if a cell is greater than 0, then look at the next cell and do the same. Then ad...
Conditional hide rows in multiple sheets
SolvedIt didn't solved yet. I have one excel file with multiple sheets, and all of them with the same columns and rows . I need to hide specific rows in ...
How to copy entire row (urgent)
SolvedHi people. i am doing on some assignment for school. I have created a userform with a search button embedded on one worksheet, lets call it SE...
How to display formula in excel?
Solvedhi everyone, for example i have A1=H and A2=G, and A3=A1+A2 how do i make A3 show a final result of "H+G",display text instead of calculating the form...
Excel skipping a cell when calculating a tota
Solvedi have a series of codes back and forth it seems a bit insane. but what im wanting is for cell b1 c1 d1 e1 and etc to add together wich i have the fo...
