$$Excel-Macros$$ Re: Need help with making a macro revolving around finding certain numbers from a list

2014-06-14 Thread Noah Shalii
Sorry I'm an excel noob, I don't understand what to do. On a side note though, i was wondering what the formula would be if it was just to find whether Cells(1, 1).Value exists in row B, and where it would be. Also what would the formula for selecting the bottom row with a value in it be? Sorr

Re: $$Excel-Macros$$ Re: Need help with making a macro revolving around finding certain numbers from a list

2014-06-14 Thread Vaibhav Joshi
Hi Check yellow cells.. Cheers!! On Sun, Jun 15, 2014 at 11:05 AM, Noah Shalii wrote: > Hi, thanks for the help. > However, this only seems to work with the set of values I provided as an > example. > i was wondering if there is a way it would work with any set of numbers I > add to the A col

Re: $$Excel-Macros$$ Here is a Great Challenge - Retrieve data in from a multiple urls in one step

2014-06-14 Thread Vaibhav Joshi
Zolf can you share final result. Cheers!! On Thu, May 15, 2014 at 2:33 PM, Frank Zolf wrote: > Nice try, but this inverts the output and there is too much movement. So, > it's not scalable. > > Anyone else? Challenge closes 10:00 GMT 20/05/2014. > > > Optimise processor use and query interval

$$Excel-Macros$$ Re: Date Format Query

2014-06-14 Thread GENIUS
look at the result -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

$$Excel-Macros$$ Re: Need help with making a macro revolving around finding certain numbers from a list

2014-06-14 Thread Noah Shalii
Hi, thanks for the help. However, this only seems to work with the set of values I provided as an example. i was wondering if there is a way it would work with any set of numbers I add to the A column. Thanks On Sunday, June 15, 2014 2:09:39 AM UTC+9, Noah Shalii wrote: > > Hi, I am in need of

Re: $$Excel-Macros$$ Xlsm Password removal

2014-06-14 Thread xlstime
Please follow group rule.. see rule number 3. . Enjoy Team XLS On Sat, Jun 14, 2014 at 11:58 PM, Revathi Nair wrote: > Hello friends, > Please help me to remove password of attached excel file. > > Thanks in advance ! > > Revathy > > -- > Are you =EXP(E:RT) or =NOT(EX

Re: $$Excel-Macros$$ Need help with making a macro revolving around finding certain numbers from a list

2014-06-14 Thread Kranti Srivastava
Hi, Please ignore previous mail and consider this one... Thanks, Kranti Srivastava On Sun, Jun 15, 2014 at 2:22 AM, Kranti Srivastava < krantiexcelma...@gmail.com> wrote: > Hi, > > Please find attached > > Thanks, > Kranti Srivastava > > > On Sat, Jun 14, 2014 at 10:39 PM, Noah Shalii > w

Re: $$Excel-Macros$$ Need help with making a macro revolving around finding certain numbers from a list

2014-06-14 Thread Kranti Srivastava
Hi, Please find attached Thanks, Kranti Srivastava On Sat, Jun 14, 2014 at 10:39 PM, Noah Shalii wrote: > Hi, I am in need of help making a macro formula for excel. > > I apologize in advance for my poor explanation, but I am trying to create > something which will; > 1. check the number

$$Excel-Macros$$ Need help with making a macro revolving around finding certain numbers from a list

2014-06-14 Thread Noah Shalii
Hi, I am in need of help making a macro formula for excel. I apologize in advance for my poor explanation, but I am trying to create something which will; 1. check the number in row 1 column A 2. see if that same number is present in column B(any row) 3. if it is anywhere in column B, add 1 valu