The discussions
Copy comments from sheet to sheet
I am using this formula: =IF(ISBLANK(Master!A1),"",Master!A1) If A1 on the 'Master' sheet has a comment, how can I bring it to the sheet I am u...
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 ...
Formula is too long....
Can anyone simplify this? =IF(SUM(COUNTIF(M198,"Y"),COUNTIF(M200,"Y"),COUNTIF(M202,"Y"),COUNTIF(M204,"Y"),COUNTIF(M206,"Y"),COUNTIF(M208,"Y"),COUNT...
Help with counting in excel with a condition
Hi, I would like Excel to count a range of non-blank cells and enter the number but if all the cells in the range are blank, I'd like it to fill in w...
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...
Spreadsheet comparison
I have a project that I am working on. Although the example uploaded is very simple, it's what I am looking for. I have a Master 'Sheet 1' and a Val...
Add colored cell values in column
i want to add cell values in a column which are of red font color. for ex. i have a column a of range a1 to 10 and values are below and 20,50,70,100...
Recording keys strokes.
I have a complex problem and I would like to demonstrate my requirement to a consultant by showing him what I need to be done by a video of the keystr...
Forgot yahoo password and question..
Configuration: Mac OS X / Safari 528.16 sir i forgot my yahoo password and that stupid question... My id is pb07q0309@yahoo.in please sir i really ...
How do you by pass the password
hw can 'i by pass the password dialog box for the user account which is the administrator of the computer
Drop down with formula
Configuration: Windows XP / Safari 532.5 in excel i want to use a drop lown list and when enter specified text, then next cell should display my speci...
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
Word file corrupted
Configuration: Windows XP / Opera 9.64 my word documents are all corrupted by virus.now i ve cleaned all virus but the files are still corrupted.whil...
Mmc password
Hello, i have a Kigston micro sd card for my phone 7210 supernova and its password protected and i forgot password i cant open it from my phone or...
Mybook password
Hi, i recently book a mybook essential, 1TB. I installed it and applied my password, no problems. after that, i happened to need to reformat my comput...
I forgot it my pass word
i forgot my orkut pass word please find it Configuration: Windows XP / Safari 532.5
Conditional formating for date range
dear sir, i want to make time sheet for each workers in thetime sheet first col is date range i formated as sat 5/1, sun 5/2 like this in this i...
Select value from cell if 2 criteria are met
I stumbled upon this forum when trying to find this answer in Excel. Hopefully you all can help. Here's the deal: I have a spreadsheet that has ...
Numerical value to change in words.
HELLO, HOW CAN I CHANGE OR PUT THE VALUE OF NUMERICAL INTO VALUE IN WORDS. SUPPOSE IN EXCEL SHEET, I HAVE MENTION 25000 USD , HOW CAN I PUT F...
How do i fill in a form from otheer data
I have a 1st tab Form in an Excel spreadsheet that I need to have it fill in automatically by placing a number into the form that corresponds with dat...
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 ...
Help i am making a macro in excel
I am trying to creat a macro. I have a Graph on its own chart page. I want to be able to click on a box on the graph page and have it take me to the...
Formula for percent for ei.. d1 and e1 equals
I have two rows... Say D1 (16,597) and E1 (30,725). Want to find out how to get percentage formula to show that 16,597 is 54.01790% of 30,725 Config...
Date conversion
What is the easiest way to convert an unaccepted excel date format: "Jan 2/2008" to an excel understood date format such as "1/2/2008" without doing i...
How can i open my email i forget my password?
how can i open my email i forget my password?
Date formatting
I have formatted a cell for month, day & year as follows: 00/00/00. I then type 042110 and it appears as 04/16/15. Any suggestions? Configuration: ...
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...
Countdown formlua - urgent - got an exam tomm
How to do this? How to write this algorithm? an algorithm called Countdown accepts as input an integar N. The value of N lies in the range 1 to...
Move rows to a new sheet
Hi, I have an sheet with thousands of rows. I am looking for a way to move all the rows that have similar data in the cloumn A feilds. Hope it is ...
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...
Excel help
I have two different Excel files, one with a complete list of serial numbers and one with some of the same serial numbers and also some that may not b...
Creating a graph in excel using drop downs
I have a file, that we are tracking leads. In the file, we have several components, but 2 specific components I'd like to graph. We have a Date Colu...
Memorycard password
im using 5220 nok music xpress.. mobile got hanged i formated the card now asking for the code wat should i do plz help me out Configuration: Windo...
To find cells with same values
How to find cells with the same values in column 'A' ,how to add values of the corresponding cells of column ' L ' and put sum in column 'M' ? ...
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...
Macro that shows the contents of a range
Hello, I'm trying to create a macro that would show the contents of a range of cells. I would like to assign this macro to the botton on the forms...
Need help in excel...
Hi All, I need to populate the columns(multiple columns) of excel with the values from the previous non - empty column. The problem I am facing is...
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...
Amt in words in word
want to convert amt in words in word indian format Configuration: Windows XP / Internet Explorer 6.0
Forget my password
hi i am forget my password and plz help me if u can
Writing text in farsi in msword 2003
hello there, I have Windows XP on my computer as the operating system and MSWords 2003. I have been trying to use Farsi with my MSWord. When I go to...
Dates not formatting correctly
Hi, I'm trying to format Dates as dd/mm/yyyy in excel, but my dates after 31/12/1999 are not been formatted correct. i.e 01/01/2010 is not being recog...
Help on formatting dates
Hi, I'm trying to format Dates in Excel using custom and dd/mm/yyyy. but Excel is actually getting confused and this the mm is the dd. Any da...
Same values in a column
How to find cells with same values in a column? eg) A 1 1 2 1 3 1 4 2 5 2 ...
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...
Macro to insert rows on click of a button
I am trying to auto populate a list one below the other on the click of a button. A sample sheet of what I am proposing can be found at the followi...
Two ways sort of vlookup, pls help!!!?
Col A Col B Col C Jack Kate 1-Apr 7:30 PM 7:30 PM 2-Apr 7:30 PM 7:30 PM 3-Apr 5:30 PM 5:30 PM 5-Apr 7:30 PM 7:30 PM 6-Apr 7:30...
If formula require to calculate no of days
Hi, I have four dates in my work sheet, among them 2 are fixed and two variables. The data is as follows: Date of Purchase (DP) = variable Da...
