It has taken 10 years but I have eventually got to my 1000th post.
It has taken 10 years but I have eventually got to my 1000th post.
click on the * Add Reputation if this was useful or entertaining.
I guess, congratulations?
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you.
Congrats on your 1st 1K
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That mean it's going to be 320 years before you match Ford?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
@ Tevor - 32?
or are you counting on my posts continuing to climb?
No, 10 years for 1000; you have 32,000+. So, 32,000 / 1000 x 10. Good example for a spreadsheet, maybe?
OK, I was having a brain pharght LOL
I remember when Ford joined and then saw the rate of his answers I imagined he has a factory of elves all answering in his name.
haha when I 1st joined, I couldnt believe how many q's I could help with
and still do!!!
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
That would be pronounced FARFFT! Ford
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Back then guys (like I have said before) I thought I was good at excel - until the REALLY good guys on here showed me what good looked like
This one looks that is first Ford's question!!
Edit:
By the way. This looks that is my first post here. Take a look to see who are the repliers!
Last edited by Fotis1991; 12-15-2015 at 03:53 AM. Reason: Edit
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
wow, very interesting, both of those threads
Huh, when I joined I was the one asking the questions. I tried to find one my first questions ,but the database does not want to play ball. It was "How do you count non blank cells in range("A1:A20")?" At the time, I could only use Sum and VLookup, LOL. VBA, what was that? Lucky I had Romperstomper teach VBA and he is a very good teacher.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
http://www.excelforum.com/excel-gene...ml#post2088570
I have been a lurker for a while, but this is my first post .
I have not a hope of explaining this without a pic, so I hope this helps.
In the attachment at the bottom of the page I want to count the symbols in the blue selected area when they are apear into the cells in the red selected area. The catch is that I want to treat the each of the "RED", "BLUE", "GREEN" as a single colum so to speak and have a value "1" or "0" apear in the back circled area.
Eg, For MrB there is nothing in the "RED" column (B7:D7) so that gives a value of zero in cell cell "P7". In the "BLUE" column (E7:G7) there is a circle which will give a value of "1" in cell "Q7". In the "GREEN" column (H7:I7) there is a double circle and a square symbol and that will return a value of "1".
I hope this makes sense. I have tried to do this with counta, but that will also count cells when a space bar is used and that makes it difficult to make sure that I am getting the right info. I also tried VLOOKUP and COUTIF but this is beyond my level. I hope someone can help.Cherrs.
Regards, TMS
Ha,Ha, I did the worst thing you could do, posted a pic instead of a file!!!!
Nah, not the worst thing
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks