Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-26 Thread Vicky
Hi Greg, The given code only works when you are comparing the contents of the entire cell from one in the range. It won't work if your chkFor cell is matching partially with one of the cells from range. Regards, Vicky On 26-Jan-2017 9:47 PM, "Greg Della-Croce" wrote: > Vic

$$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-26 Thread Vicky
tion The above code worked for me. :) Regards, Vicky On Thursday, January 19, 2017 at 7:15:03 PM UTC+5:30, Greg Della-Croce wrote: > > I am trying to create a very simple function that will take a string of > text and read a range of texts to see if I have any that string in any

$$Excel-Macros$$ Run code when new cells are added (and only on newly added cells)

2016-02-06 Thread Vicky Jorwal
added cells but not on existing cells. For example, I want to add the date on which the each entry is added to the database. Looking forward for an amazing answer:) Thanks Vicky -- 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 Fac

$$Excel-Macros$$ Re: purchase sales in excel

2015-12-29 Thread Vicky Jorwal
Use Index and Match Functions It'll be easy... Regards, Vicky On Tuesday, December 29, 2015 at 6:46:37 PM UTC+5:30, hemal shah wrote: > > HI > All genius, > > In one sheet I have put purchases and in second sheet there is sales > against purchase. > > In

$$Excel-Macros$$ NETDDE

2012-06-01 Thread vicky sharma
string connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source='\\192.168.10.54\\D:\\shareff\\Excel.xls';Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnection(connString); conn.Open(); OleDbDataAdapter adapter = new OleDbD

$$Excel-Macros$$ how to get top ten values from a list

2010-02-03 Thread vicky
volume sales 1.13 2423 1.532423 2.92 33243 1.47 3243 1.49 234234 1.35 343423 3.45 32423 i need top ten sales values for volume > 1 and volume < 2 -- -- Some important links for