Hi,
Can we do this using VBA macro? I understand that excel will struggle while
searching. But is it possible? If yes, could anyone help me out? Thanks
On Wed, Apr 24, 2013 at 2:45 PM, Kanwaljit Singh wrote:
> Hello Sir,
>
> What I understand that is
> --You are using a Validation List
> --You
I am using an excel spreadsheet in conjunction with Loftware. which
requires headers in cells A1 and B1. I have formulas in A2 and B2
calculating data from C2 and D2. I'll enter data in columns C & D and then
copy the formula down in columns A and B.
My problem is when I reset the worksh
hi R.Karunanith,
You can simply use the concatenate function to do the concatenation i have
tried doing it seems to work fine for me, hope this solution works for you,
i just tried helping, it it does'nt work please forgive me.
Thanks & Regards
Amit Basra
On Wed, Apr 24, 2013 at 10:42 PM, karu
Sirs,
I want to fill down Sim card numbers around 5 lacs each contain 19 digits
and the sims have numbers from one value to another, in sequence for 5 to
10,000.
I split this to 3 or 4 columns and then idea to concatenate. The numbers in
sequence
is highlighted in yellow.Using a macro i can m
HI PRITI
THNK U ONCE AGAIN
BUT IF THE actual value is more than sum OF ( H5,J5) it shoud not allow
to enter the column neither h5 nor j5)
regardS
On Wed, Apr 24, 2013 at 7:48 PM, priti verma wrote:
> Hi GRKRISHNA,
> Please find the attachment.
> Thanks
> Priti verma
>
>
> On Wed, Apr 24,
Hi GRKRISHNA,
Please find the attachment.
Thanks
Priti verma
On Wed, Apr 24, 2013 at 7:36 PM, GRKRISHNA NAIDU wrote:
> dear PRITI VERMA
>
> THNKS FOR YOUR HELP
>
> WILL YOU PLEASE SHOW ME IN WORK SHEET
>
>
>
>
> On Wed, Apr 24, 2013 at 7:27 PM, priti verma wrote:
>
>> Hi GRKRISHNA,
>>
>> Pleas
dear PRITI VERMA
THNKS FOR YOUR HELP
WILL YOU PLEASE SHOW ME IN WORK SHEET
On Wed, Apr 24, 2013 at 7:27 PM, priti verma wrote:
> Hi GRKRISHNA,
>
> Please use this formula in your data validation.
>
> =IF(SUM(H5+J5)-F5<=F5,"true","false")
>
> Regards;
>
> Priti verma
>
>
> On Wed, Apr 24, 20
Hi Amar,
If you are using Database function ..please ensure that all header name are
same i.e.. database,field, and criteria...
Your formula is working fine.. but you have changed header name see cell H11
Regard,
Santy
On Wed, Apr 24, 2013 at 3:29 PM, अनिल नारायण गवली
wrote:
> Dear Amar,
>
Hello Sir,
What I understand that is
--You are using a Validation List
--You want that When you start typing in the cell, the entries in
validation list start reducing to those matching the words, like a
wild-card search.
It that is true, I don't think there is any Excel Add-in for such purpose.
Hi, Thanks for taking time out and helping.
Does auto correct work even for names? Example, in column A, I have
names as following
Mathan
Raja
Ravi
if I type 'M' in column B. It should auto fill 'Mathan'.
Pls let me know if its not clear. Plz see my first post for more details. Thanks
On 22/04
10 matches
Mail list logo