The discussions

How to count rows which show specified dates

 Solved

Hello, I am trying to get help with stats. I have a spreadsheet which shows the date a specific action was started in each row. I need to be abl...

3 replies Last reply on 8 Jan 2010 by
venkat1926

Select y in all 3 columns and return value

 Solved

Hello, There are 3 columns where range is unknown for all the 3 columns( A, B & C). Macro need to selcect "Y" in all the 3 columns then No action ...

1 reply Last reply on 7 Jan 2010 by
venkat1926

Incorrect product key

 Solved

Hello, I have just purchased a new computer. A Windows 7 Acer, actually... Well, as a new computer, a Product Key is required... right? See, Micros...

1 reply Last reply on 6 Jan 2010 by
aquarelle

Reg: macro - auto run

 Solved

Hello, I need to run a macro automatically when i open an excel sheet. and aslo to run a macro when i close the sheet can any one help me...

10 replies Last reply on 5 Jan 2010 by
jee

Vlookup help

 Solved

Hello, I would be very thankful if anybody solve my problem which exactly need. The details are given beloW: DATE SCRIP NET(Cr/Dr) 19-...

1 reply Last reply on 3 Jan 2010 by
venkat1926

I receive pdf files but can't open them.

 Solved

Hello, I have windows XP and when I receive an e-mail with a PDF file attached I try to open it and all I get is grafeate. Is it the Windows XP th...

2 replies Last reply on 30 Dec 2010 by
Gunny

Macro question

 Solved

Hello, I'm trying to write a macro in excel 07 to select the last row in a range. I want it to select the last row of the range only. Does anyone...

3 replies Last reply on 28 Dec 2010 by
Jay

Excel

 Solved

Hello, I need some help. I would like to find out how many occurences of the same number occur in a column with in excel. Eample: 11111555555556666...

1 reply Last reply on 27 Dec 2010 by
venkat1926

Excel matching data

 Solved

Hello, I have two rows of data in excel one has the name of all members about 100 and the other list is of members who have paid their dues about 5...

3 replies Last reply on 21 Dec 2009 by
Kamal

Where does the reference (weekends/holidays)

 Solved

Hello, in regard to your formula in counting days. you said that a list of holidays/weekends should be created. onces it is created where does that i...

2 replies Last reply on 20 Dec 2009 by
sillyme

How to update prices in excel by %

 Solved

Hello, I have a lengthy spreadsheet (Office 2007) with stocked items and their prices, the prices are simply entered in a cell when I created the spr...

2 replies Last reply on 20 Dec 2009 by
pgh

Excel: if then else with multiple criteria

 Solved

Hello, Essentially, I would like to determine a numeric value (1-9) for the letters of the alphabet. Returning the number value in relation to a n...

8 replies Last reply on 11 Dec 2009 by
venkat1926

Vba/macro: removing titles

 Solved

Hello, I need to remove Mr/Mrs/Miss preceeding the names in one cell and copy them to another cell. Any idea? Your advice is much appreciated. i...

8 replies Last reply on 10 Dec 2009 by
Austin

I need a formula in excel?

 Solved

Hello, Hello... I have a cell A1 that show $200.00. now if am type $ 200.00 in B2 automatically A1 cell amount should show as 0 your help much ap...

2 replies Last reply on 7 Dec 2009 by
Mafrin

If statement

 Solved

Hello, Please help me with the following if statement : =IF(A1:A34"Ba","Ba","") Column A1 to A34 contains the following text :Co, Cs, Th, Nk et...

2 replies Last reply on 5 Dec 2009 by
TOBES

How can i open my files without password

 Solved

Hello, i lock the forder with "free hide folder" software, i forget the password how can i open my files without password

1 reply Last reply on 3 Dec 2009 by
closeup22

Constant in formula

 Solved

Hello, I am trying to use a input cel in excell 1) On my excel sheet I have data on A1,A2,A3,A4,A5 containing the amount of ml ink being used. ...

1 reply Last reply on 2 Dec 2009 by
aquarelle

Countif function

 Solved

Hello, I'll like to know if i can use the coutif function on multiple values? for example: =COUNTIF(E2:E30,(AND(G2:G30, "=הסתיים",A2:A30,"=11"),"=...

3 replies Last reply on 30 Nov 2009 by
venkat1926

Marcos

 Solved

Hello, I had someone help me make a marco in excel three years ago in office 2003. the mecro worked fine, but now I have installed office 2007. I can...

2 replies Last reply on 30 Nov 2009 by
aquarelle

Stay on same row when selecting next sheet

 Solved

Hello, I would like to know how to stay on the same row when selecting another sheet. My file contains 17 sheets. Sheets 2 and 5 till 16 contain...

5 replies Last reply on 26 Nov 2009 by
Trowa

Stable date

 Solved

Hello, Is there any function in Microsoft Excel where in we can get a stable date, the date should not change as it changes depending on the system ...

1 reply Last reply on 25 Nov 2009 by
aquarelle

Help with excel macro

 Solved

Hello, I am certainly a macro noob and require some help, please, :( I work at a travel agency and I have a worksheet with all of our reserves. It h...

3 replies Last reply on 24 Nov 2009 by
aquarelle

Using a named cell in a macro - same workbook

 Solved

Hello, seems simple but I'm just not getting it....I'm using excel 2003 and am trying to use a named cell on one sheet in a macro on a different sh...

3 replies Last reply on 24 Nov 2009 by
venkat1926

Activate userform in userform

 Solved

Hello, I've just started exploring the possibilities of userforms. My userform contains a TextBox named "txtAanvraagDat". In this textbox a date...

8 replies Last reply on 23 Nov 2009 by
aquarelle

Count # rows where 2 conditions are true

 Solved

Hello, I am having problems counting the # rows of problem reports where the priority = 1 and the PR is active. here is the array: PR PRIORI...

1 reply Last reply on 11 Nov 2009 by
aquarelle

Excel 2007 formula help - if cell is empty...

 Solved

Hello, Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get t...

2 replies Last reply on 11 Nov 2009 by
Melissa

Excel issue

 Solved

Hello, please give macro for hiding blank rows

1 reply Last reply on 11 Nov 2009 by
iveal

Excel: nested if formula question

 Solved

Hello, I've read some answers to similar questions, but not quite the same... How can I have *certain* results of my nested "IF" formula display...

2 replies Last reply on 10 Nov 2009 by
Tonio

For my think.com password

 Solved

Hello, i forgot my think.com password . can any one help me

1 reply Last reply on 6 Nov 2009 by
closeup22

Simple excel question (i think)

 Solved

Hello, I am putting together an XL sheet and would like to find the MAX value in a column of numbers, then return the contents of the cell next to it...

2 replies Last reply on 5 Nov 2009 by
ruh-roh

Vba excel search select paste delete

 Solved

Hello, If someone could possible help on this I would be very greatful. I have reems of data in Excel (tidal data). I'm looking to get the highs...

1 reply Last reply on 4 Nov 2009 by
Clint16

Auto_open

 Solved

Hello I have a question about Auto_open. Where do I put it in VB Editer? Do I put it in a Module, or Sheet, or Workbook. I have 3 sheets in the work...

2 replies Last reply on 2 Nov 2009 by
selflearner

Forgot password & secret question of orkut

 Solved

Hello, I m using new gmail & orkut A/c. But i forgot my ol orkut a/c's password & secret question. I want to delete my old a/c. Can anybody pls help...

1 reply Last reply on 1 Nov 2009 by
LouisSteph

Adding dates

 Solved

Hello, I am trying to find a formula that calculates dates. Like I have two boxes with a beginning and date in them, and I want to calculate the day...

1 reply Last reply on 30 Oct 2009 by
Excelguru

If iserror with 2 cells match

 Solved

Hello, If i have 2 cell that i need to match to 2 array row and print "W" or "L" if both of the cell match. This is what i have =IF(ISERROR(M...

1 reply Last reply on 30 Oct 2009 by
Excelguru

If formula

 Solved

Hello, wondering if you can help me with excel i need a formula that shows if A1 is starts with letter then give me a that first letter. If it sta...

2 replies Last reply on 29 Oct 2009 by
joan

Macro help...copying and pasteing

 Solved

Hello, I'm trying to write a macro to copy a row of cells to where the cursor is. The info is constant and the pasteing changes. I've used the "reco...

10 replies Last reply on 27 Oct 2009 by
selflearner

What is hdd (hp) master password?

 Solved

Hello, I have Windows XP and it's shut me out of me out. When I turn on it has black screen, asks for a DriveLock Password, a second I forget, then ...

1 reply Last reply on 8 Oct 2009 by
xpcman

Vba to open an excel file in notepad

 Solved

Hello, Can someone tell me the vba code to open an .xls or .csv file in notepad? thanks PM

1 reply Last reply on 8 Oct 2009 by
iveal

Conditional activation of macro button

 Solved

Hello, I was wondering if it is possible to only make a button work if there are only two cells selected. I have got a button which will copy th...

17 replies Last reply on 6 Oct 2009 by
Trowa

Excel formula for conditional formatting

 Solved

Hello, I'm trying to find a formula and instructions for shading date values in a column on a worksheet based on the month relative to today's date. ...

3 replies Last reply on 29 Sep 2009 by
venkat1926

Set password in mozila firefox

 Solved

Hello, i want to know how can i set pass word in mozila firefox which is ask me when i start or open firefox. please repy or answer in my email addr...

2 replies Last reply on 25 Sep 2009 by
Asten M

Highlight one cell based on date in a range

 Solved

Hello, Using conditional formatting I wanted to highlight one cell based on a range. I wanted for example a1 text to be highlighted when one cell or...

1 reply Last reply on 24 Sep 2009 by
coldwind

Excel date formatting problem

 Solved

So here's my problem. I have multipe dates all in one column on one tab/worksheet of an excel workbook. When I try to link to that date on another tab...

2 replies Last reply on 22 Sep 2009 by
chow70

Count a text string if criteria is found

 Solved

Hello, I have a problem and is that I want to count a text string from a range of cells, if the criteria is found correct, for example, jamshedpu...

1 reply Last reply on 17 Sep 2009 by
venkat1926

Please help with my spreadsheet

 Solved

Hello, I am having a hard time trying to figure out how to format my spreadsheet so that i can make it a template that i can use in future, this is w...

2 replies Last reply on 15 Sep 2009 by
chicky

Please help! excel question

 Solved

Hello, I am trying to figure out how to count the number of cells that contain a certain text. For example: Column A 2007 Entry Draft ...

3 replies Last reply on 6 Sep 2009 by
deepbreathe

Simple function or formula i think

 Solved

Hello, I want to set up a formula or function to display a number from another cell only if a different cell is greater then 0. Example: data in Cel...

1 reply Last reply on 2 Sep 2009 by
aquarelle

Excel 2003 question

 Solved

Microsoft Office Excel 2003 I am trying to put in todays date along with text. How would i do this? in box A43 i have: =Q1&R1&S1 in Q1 i h...

3 replies Last reply on 2 Sep 2009 by
sadgurl

Excel: copy active range to bottom of list

 Solved

Hello, On multiple sheets I have lists of peoples names. When I add a few new names on one sheet, I want a macro to copy-paste these names to the o...

13 replies Last reply on 27 Aug 2009 by
Trowa
Results 2501 - 2550 out of a total of 2,608