Posts by imported_Anonymous

• Formula (If Statement)? HELP

What I would like Excel to do is if there is an occurence of "AAA, BBB, CCC, etc." in cell A2, I need Excel to place a "1" in the column underneath the appropriate "AAA, BBB, CCC, etc." label heading. Sorry if I didn't state the question correctly. Any further suggestions?

Thanks!

• Formula (If Statement)? HELP

How would I write a formula, possibly an IF statement, that if text items such as the following, "AAA, BBB, CCC, or DDD" are entered into a cell, that Excel can place a "1" in another cell underneath columns for "AAA, BBB, CCC, DDD, . . . etc."?

• range

hi! i'm a beginner in excel and i was wondering if you can enter a range formula in excel. for example, if you enter a number that falls between 1 - 10 then another cell will display "passed" or something like that. hope you can help me.:puzzled:

• Macro for data transfer

Hi Dave,
Have several excel files (10000 rows x 20 columns) sorted out by column A.
Need a macro to split them in several sheets at each change of column A and rename each sheet with the name of column A. The change in column A varies from file to file.
Thank you
Chris

• looping through values in cell

This code works on the example given

Sub DelNumbers()

Dim c
Dim d
Dim CellEntry

For Each c In Selection
CellEntry = ""
For d = 1 To Len(c.Value)

If IsNumeric(Mid(c.Value, d, 1)) Or c.Value = " " Then
c.Value = Trim(CellEntry)
Exit For
Else
CellEntry = CellEntry & Mid(c.Value, d, 1)
End If

Next d

Next c

End Sub

HTH

• SUM More than 30??

Thanks :spin: it works great!

• SUM More than 30??

I need some help with a formula to SUM more than 30 numbers. Specifically, I need to SUM even-numbered rows, (G2:I2, G4:I4, G6:I6, . . .all the way to G62:I62) Since this formula has 31 numbers, Excel gives me an error and says that it can only SUM 30 numbers. Is there another formula that I can use to help me calculate this? Thanks in advance.

• Formula for Number of Days in Month

[You can use following:

=DAY(DATE(YEAR(D22),MONTH(D22)+1,0))

where D22 holds the date ]

I'm new to Excel so please excuse, if I type the above formula into a cell, where would FEB and 2003 be entered so that the formula could calculate "28", the number of days in February, 2003?

Thanks

• URGENT: Formula [or something] required ...

I'm desperately in need of a formula (or something) which will allow me to do the following:

I have a list, which is laid out as a number list, from 1 to 20, with corrosponding numbersi n then ext column (i.e. number 7 = 32, etc)

Is there a way in which, when I enter the number into another cell, it will then display that corrosponding number accordingly, and then when it is cleared and a new one entered, it displays the new, relevant number?

• Formula for Number of Days in Month

Is there a formula that I can use to calculate or insert the number of days in a month? Thanks

• Protecting Form Objects

I have added some form objects to a number of sheets eg Option Box and Checkboxs.

I wish to protect the Worksheet yet want users to be able to toggle these boxes.

I have unchecked the LOCKED in the Protection Tab in both the Format Control of the objects and also the cells in which the objects are placed.

However when I protect the Worksheet I cannot use these checkboxes as it says the cells are protected.

Any suggestions.

• Show blank cell

Thanks Rennie. That has worked. I have found a great deal of info on this site. I hope it keeps going. Thanks again...

• calculation for bytes per second

Thanks much. I do still need to investigate how to test for zero duration (start time = stop time).
Mike

• Color of Cursor

Is there a way to change the color of the cursor? For example the standard cursor is ourlined --- but at times it is hard to see where it is at in a spreadsheet. It would be great to see the cell highlighted where the cursor is. Any suggestions?

• Having trouble with...

Quote

Originally posted by Bohunk
Thanks for the help guys, it works with this:

txFoodDiscounts = Format(Val(txmpDisc1.Value) + Val(txmpMiscDisc.Value), "\$0.00")

own up! Mr XL just beat this site to the answer!!! :bouncy:

chorus of air guitar....:guitar::guitar::guitar:

• calculating results to todays date

i get the idea. Although im currently not getting anything other than the formula coming up when i enter it, although i am assuming c9&gt;0 on your example to be the location of perm sd rather than an empty cell, which could be the problem.

Probably would of been easier to start it all in Access - but whatever doesnt kill you makes you stronger eh ?

Thanks for your help all the same.

ROB

• personal.xls

Lets see ... when I tried to set up the personal.xls, I created a macro, told it to put it in the personal.xls, closed Excel down, re-opened it up, but the pesonal.xls won't load. That is my problem. It is where it is suppose to be, but won't load. If I create another .xls file and put it under the same XLSTART, the newly created file will load ... but not the personal.xls. I had even removed all of Excel, and then reloaded it from scratch. Still the same thing. The only thing is, I have put the same macros on 6 other machines and this is the only one causing me a problem.

• Increase "Name Box" display size

Quote

Originally posted by tejas57
Is there a way to increase the "Name Box" display size? The display is located in the upper left corner of the Excel display.

I use Excel Names extensively and cannot distinguish between long names.

thanks.

Hi,

Chip Pearson also has some VBA code on his site to increase the size of the Name Box. It's available at:

http://www.cpearson.com/excel/NameBox.htm

Cheers,

John

• Show blank cell

Thanks for the help. I did try that and it is not working. I have to use the military time and in my formula it changes to 24 when I deselect the zero value. I am lost....

• excel 2002 sheet protection

It does not matter what complexity your password is. In sheet protection all paswwords are cracked instantly.