need help with excel

Reply #7

phileight — Tue, 28 Apr 2009 16:12:57 GMT

Hillbilly

The problem with memory it tends to forget minor details.

open your spreadsheet. alt F11. then select tools. then macro. create a macro. I used check as macro name but you can use any name .

you should now see your macro name followed by (), a blank line, then end sub paste the file starting at the blank line.

delete one of the macro names and one of the end sub statements. if you used check as the macro name then the file should look like my earlier post.

VBA

Reply #6

hillbilly953 — Tue, 28 Apr 2009 13:22:51 GMT

I done the first part copy my file in new sheet done that ok

then I pressed alt f11 and it comes up with gray window I dont see a place to paste in your formula. Would it be possible for you to do it for me and send sheet email?

If so numbers in my sheet would be 80 sets say A1- A80 B1- B80 C1 -C80 D1- D80 E1-E80 - F1-F80

NOW THESE CELLS HAVE MY 3 DIGIT NUMBERS TOTAL OF 480

tHANKS HILLBILLY

Reply #5

phileight — Tue, 28 Apr 2009 00:51:33 GMT

sounds like you need a vba program.

copy your file to a new spreadsheet. copy the code below. open your new spreadsheet.

press alt f11 then paste the code. close window.

put your lowest # in row 2 col G your highest in row 2 col H.

press alt f8 run macro check .

if you like the results you can repeat the steps above in your original spreadsheet. if not delete the new spreadsheet

p8

Sub check()

Dim m(160, 8)' slightly larger than your data file

Row = 2

Cells... [ More ]

Reply #4

hillbilly953 — Tue, 28 Apr 2009 00:43:35 GMT

I have a problem my numbers are like this 254 not 2-4-5 and it will only show you 1 st number

I need something that can find duplicates in all my cells 150 of them.

i want only the numbers that have exact match in them 235 235 235 235 235

what i have some thing that produces 150 numbers say 20 of them duplicates and thats the ones I want to look at.

Thanks for your time

Reply #3

hillbilly953 — Tue, 28 Apr 2009 00:32:56 GMT

See thats what I don't want to do is tye in ever number to look for. Just say you had 500 numbers in cells I want to find all the numbers it got in it that are exact match or dupicates of them that are in cell.

Thank you

Reply #2

diamondpalace — Mon, 27 Apr 2009 23:46:57 GMT

Try the Straight Eliminator sheet I have created. It also count how many str are within the count range. Would need to change the black color into white to see the counts, do this after you have paste in the numbers on white column under the Clear All button. Pink box next to the str combos indicating 0 hit.

Reply #1

cindabar — Mon, 27 Apr 2009 23:36:08 GMT

Place your cursor any where in the cells the hold down CTRL key and press F (CTRL+F) to launch the Find window. Place the number you are searching for in the Find What window. Set options to value ,then press find all. If you like you can highlight all the found values by selecting the first cell listed, hold down the SHIFT key and select the last listed (all will be selected). Select a fill color to easily see all instances of your straigt hit.

Hope this helps

need help with excel

hillbilly953 — Mon, 27 Apr 2009 22:55:36 GMT

My problem is this I got a xl page it has 400 numbers in it all in diffront cells A1-A150 -- E1--E150

now I want to find only the numbers that are in all the cells STRAIGHT only that show more than 1 Times

like 225 cell a5 225 e100 cell b90 225 hope this can be done in some easy way.