Loading User Information from Channel 9
Something went wrong getting user information from Channel 9
Loading User Information from MSDN
Something went wrong getting user information from MSDN
Loading Visual Studio Achievements
Something went wrong getting the Visual Studio Achievements
VB Man
Year of the Linux MCE.
I'm looking for a formula to do this...
RoyalSchrubber
One. How many time travellers does it take to change a lightbulb?
If that VB in your name is abbreviation for 'Visual Basic' then I think you're capable of doing it yourself - as you see, like Word, Excel too is scriptable with dialect of Basic called Visual Basic for Applications (VBA).
VB Man
Year of the Linux MCE.
The point was to make it without using VBS for Office.... hence 'Excel Formula'.RoyalSchrubber said:If that VB in your name is abbreviation for 'Visual Basic' then I think you're capable of doing it yourself - as you see, like Word, Excel too is scriptable with dialect of Basic called Visual Basic for Applications (VBA).
I probably could manage to write it, but I'm too lazy and I don't even have Office installed on this computer. (MSDNAA doesn't provide me with it so I'm on openoffice)
Hi!VB Man said:The point was to make it without using VBS for Office.... hence 'Excel Formula'.RoyalSchrubber said:*snip*
Anyways, countif seems to have done the job I needed it to.
JoshRoss
:::METRO:::
=IF(COUNTIF(A1:A5,"100")=3,"WhooHoo","HooWoo")
© 2012 Microsoft. Except where designated as licensed by
Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License,
Microsoft reserves all rights associated with the materials on this site.
Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.