The discussions

Copy data next to a cell and paste it below

 Solved

Hi, 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 ...

5 replies Last reply on 7 May 2010 by
kent5244

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...

5 replies Last reply on 7 May 2010 by
rizvisa1

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...

1 reply Last reply on 7 May 2010 by
rizvisa1

Macro assistance

 Solved

I have a spreadsheet that has data ranging from C3:C263. Workbook is 'GSU CAS Transactional Upload', Sheet is called 'Alliance Upload' I need to...

4 replies Last reply on 7 May 2010 by
DCecil07

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...

6 replies Last reply on 7 May 2010 by
DCecil07

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...

4 replies Last reply on 7 May 2010 by
rizvisa1

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...

4 replies Last reply on 7 May 2010 by
B-Bee

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 ...

1 reply Last reply on 7 May 2010 by
closeup22

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

1 reply Last reply on 7 May 2010 by
closeup22

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...

1 reply Last reply on 7 May 2010 by
rizvisa1

Convert a date figure into word in excel

 Solved/Closed

I want to know the formula, how can I convert a date figure into word in excel 2003

Last reply on 7 May 2010 by
rizvisa1

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...

1 reply Last reply on 7 May 2010 by
dist.urbd

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...

1 reply Last reply on 7 May 2010 by
closeup22

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...

1 reply Last reply on 7 May 2010 by
dist.urbd

I forgot it my pass word

i forgot my orkut pass word please find it Configuration: Windows XP / Safari 532.5

1 reply Last reply on 7 May 2010 by
closeup22

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...

1 reply Last reply on 7 May 2010 by
rizvisa1

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 ...

1 reply Last reply on 7 May 2010 by
rizvisa1

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...

1 reply Last reply on 7 May 2010 by
closeup22

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...

1 reply Last reply on 6 May 2010 by
rizvisa1

Excel macro to repeat and insert rows

 Solved

I am trying to write a macro that will insert rows as follows: Col 1 Col2 Col3 1 S 456 2 A 222 3 M ...

1 reply Last reply on 6 May 2010 by
rizvisa1

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...

1 reply Last reply on 6 May 2010 by
rizvisa1

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...

1 reply Last reply on 6 May 2010 by
rizvisa1

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...

1 reply Last reply on 6 May 2010 by
rizvisa1

How can i open my email i forget my password?

how can i open my email i forget my password?

1 reply Last reply on 6 May 2010 by
ilhaan

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: ...

1 reply Last reply on 6 May 2010 by
rizvisa1

Link question

 Solved

Using 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 ...

4 replies Last reply on 6 May 2010 by
rizvisa1

Macro for array vlookup to worksheet

 Solved

Looking for help with a quick macro please. I have four tabs in the workbook: Datadump - contains daily raw data to clean Central - Accou...

14 replies Last reply on 6 May 2010 by
rizvisa1

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...

1 reply Last reply on 6 May 2010 by
rizvisa1

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 ...

1 reply Last reply on 6 May 2010 by
rizvisa1

Need help with excel message pop up

 Solved

I 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...

6 replies Last reply on 6 May 2010 by
Trowa

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...

3 replies Last reply on 6 May 2010 by
rizvisa1

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...

1 reply Last reply on 6 May 2010 by
Trowa

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...

1 reply Last reply on 6 May 2010 by
closeup22

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' ? ...

3 replies Last reply on 6 May 2010 by
rizvisa1

Updating data in two+ worksheets

 Solved

I 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...

1 reply Last reply on 6 May 2010 by
rizvisa1

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...

3 replies Last reply on 6 May 2010 by
rizvisa1

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...

2 replies Last reply on 6 May 2010 by
rizvisa1

Conditional formatting with 3 cell

 Solved

Hi 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...

5 replies Last reply on 6 May 2010 by
rizvisa1

Amt in words in word

want to convert amt in words in word indian format Configuration: Windows XP / Internet Explorer 6.0

1 reply Last reply on 6 May 2010 by
closeup22

Forget my password

hi i am forget my password and plz help me if u can

1 reply Last reply on 6 May 2010 by
ash_perez01

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...

1 reply Last reply on 6 May 2010 by
ash_perez01

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...

1 reply Last reply on 6 May 2010 by
ash_perez01

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...

1 reply Last reply on 5 May 2010 by
venkat1926

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 ...

5 replies Last reply on 5 May 2010 by
TIGERsHAKER

Link data

 Solved

Dear 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...

14 replies Last reply on 5 May 2010 by
YeohSeow

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...

1 reply Last reply on 5 May 2010 by
Alex

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...

2 replies Last reply on 5 May 2010 by
Adit

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...

7 replies Last reply on 5 May 2010 by
rizvisa1

Help sorting an excel sheet

what formula or marco could I use to allow employees to just bring up their data on a spread sheet using their ID IE Col. D is all the IDS F and...

3 replies Last reply on 5 May 2010 by
rizvisa1

Problems with dtpicker control

Hello, I want to create a userform and I have some issues - I hope that I can find any help here.Thank you. 1. DTPicker Control. 1.1 How can...

1 reply Last reply on 5 May 2010 by
rizvisa1
Results 8701 - 8750 out of a total of 12,267