Thanks for asking this query.
Appreciate your mind !!!
And also thanks De Pemor for the solution.
Have a great day all !!!
On 7/29/13, Kannan Excel kannan.ex...@gmail.com wrote:
Hi,
I want to set particular date and* time* also for expire is this
possible.???
Or i want to set date
Respected Cute Awsome,
You can find cracks and activation keys for download.Just google for
windows 7 activation keys or download a cracked version and install.Then
you will not receive the message.
Regards,
Vijaykumar
On Sat, Jul 27, 2013 at 4:38 PM, Excel Learn excellearn2...@gmail.comwrote:
try this attached file
user, pass, and expiration date defined in a sheet
On 29/07/2013 13:05, Mangesh Vimay wrote:
Thanks for asking this query.
Appreciate your mind !!!
And also thanks De Pemor for the solution.
Have a great day all !!!
On 7/29/13, Kannan Excel kannan.ex...@gmail.com
how to make this???
can u send code???
and if i type user and pswd means, permission granted or user has expired
message only appear...
excel sheet not open...
On Mon, Jul 29, 2013 at 1:16 PM, De Premor d...@premor.net wrote:
try this attached file
user, pass, and expiration date
can u do me a favor???
i don't want user and pswd...
i want vb coding for expire date and time
pls send that code how to set date and time to expire
On Mon, Jul 29, 2013 at 1:16 PM, De Premor d...@premor.net wrote:
try this attached file
user, pass, and expiration date defined in a sheet
thanks thanks a lot i am really happy.
On Mon, Jul 29, 2013 at 2:13 PM, De Premor d...@premor.net wrote:
sorry little mistake there, try new attached
On 29/07/2013 15:37, Kannan Excel wrote:
how to make this???
can u send code???
and if i type user and pswd means,
please help me on the macro..
On Sun, Jul 28, 2013 at 10:14 AM, Puttu * puttu...@gmail.com wrote:
Any updated on the macro team..
On Sat, Jul 27, 2013 at 7:14 PM, Puttu * puttu...@gmail.com wrote:
Experts your assistance is much appreciated.
On Sat, Jul 27, 2013
Hello Ayush,
I just want to know the functionality of offset. How to use it.
Note - I am able to use Vlookup, index, match. But unable to understand the
offset option. Please guide me asap.
Thanks,
Sonu
On Thursday, March 7, 2013 9:36:29 PM UTC+5:30, Ayush Jain wrote:
Dear members,
Let's
Respected Sonu,
Please look into the following links for explanation.There are also other
links on the net, but these may help you undersatnd OFFSET function better.
http://www.myonlinetraininghub.com/excel-offset-function-explained
http://www.youtube.com/watch?v=kvXToxeiS6Y
Try to use this in cell B2
*=VLOOKUP($A2,INDIRECT(' B$1 '!$B$2:$R$302),16,FALSE)**
*
Copy it down
Pada 27/07/2013 20:44, Puttu * menulis:
Experts your assistance is much appreciated.
On Sat, Jul 27, 2013 at 4:55 PM, Puttu * puttu...@gmail.com
mailto:puttu...@gmail.com wrote:
Hi
ups sorry, please ignore my last email, i've replied a wrong topic
My bad
:-\
Pada 29/07/2013 19:37, De Premor menulis:
Try to use this in cell B2
*=VLOOKUP($A2,INDIRECT(' B$1 '!$B$2:$R$302),16,FALSE)**
*
Copy it down
Pada 27/07/2013 20:44, Puttu * menulis:
Experts your assistance is much
Try to use this in cell B2
*=VLOOKUP($A2,INDIRECT(' B$1 '!$B$2:$R$302),16,FALSE)**
*
Copy it down
Pada 29/07/2013 18:22, Dhaval Shah menulis:
here with attach a file for reference
On Mon, Jul 29, 2013 at 4:49 PM, Dhaval Shah todhavals...@gmail.com
mailto:todhavals...@gmail.com wrote:
Dear seniors,
How can we use sum sumifs , countif countifs. and what is the diffrence
between. pls explain with formula and example. pls help me.
thanks
Ashish
--
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
Sumif - used to sum the range by checking single condition.
Sumifs - used to sum the range by checking multiple conditions.
Countif - used to count the range by checking single condiyion.
Countifs - used to count the range by checking multiple conditions.
On Jul 29, 2013 8:28 PM, Ashish Kumar
Hi Ashish,
Just go through this link... you have good examples...
http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/
Thanks,
Raj
On Mon, Jul 29, 2013 at 8:41 PM, Prabhu Pinky prabhupin...@gmail.comwrote:
Sumif - used to sum the range by checking single condition.
Sumifs -
Put = sign in cell A2 itself at the bagining of the text... :P
On Sun, Jul 28, 2013 at 1:46 PM, De Premor d...@premor.net wrote:
create defined name in example : *Eval**A2* that referring to
=EVALUATE(A2)
Then in some cell in that sheet, just type *=EvalA2**
*
Pada 28/07/2013 14:59,
Dear Rajasekhar,
THanks
On 29 July 2013 21:00, Rajasekhar Praharaju
rajasekhar.prahar...@gmail.comwrote:
Hi Ashish,
Just go through this link... you have good examples...
http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/
Thanks,
Raj
On Mon, Jul 29, 2013 at 8:41 PM,
Dear Prabhu,
THANKS A LOT.
On 29 July 2013 20:41, Prabhu Pinky prabhupin...@gmail.com wrote:
Sumif - used to sum the range by checking single condition.
Sumifs - used to sum the range by checking multiple conditions.
Countif - used to count the range by checking single condiyion.
Countifs
Greetings,
My name is Don Barton and I am a laboratory informaticist at a small
hospital in beautiful Colorado, USA. I've done a lot of work in Access,
but am needing to learn VBA in Excel. Look forward to interacting with you
all.
Don
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Hey
Welcome on the board.
On 29 Jul 2013 22:18, Don Barton donaldb...@gmail.com wrote:
Greetings,
My name is Don Barton and I am a laboratory informaticist at a small
hospital in beautiful Colorado, USA. I've done a lot of work in Access,
but am needing to learn VBA in Excel. Look forward
Dear Team
I have a Query. Let says I have a column in which multiple denominations
are written. for example, A1 contains 1000, a2 contains 100 and A3 contains
500. Lets say I have 140 Such Cells in same column A. If I wish to count
how many have a particular denomination, or the number of
Greetings,
We have a scanner we use to scan a barcode for blood units for a hospital
into an Excel spreadsheet. The scanner reads the entire barcode, but we
want to remove 00 at the end of the scanned string. If there isn't 00
at the end, make it null cell. We are using the correct
just remember, that i also not yet introduce my self :(
then let me introduce my self
You can call me *De* *Premor* and i am working in Network and
Infrastucture Division at intermediate Palm and Oil Mills in beautiful
Borneo, Indonesia, i love to learn programming in my spare time since i
Hey
Use this formula: =SUM(IF(FREQUENCY(A2:A10,A2:A10)0,1))
Where A2:A10 is range of your data.
Thanks!!
On Mon, Jul 29, 2013 at 10:27 PM, Kush Shama kushleshsha...@gmail.comwrote:
Dear Team
I have a Query. Let says I have a column in which multiple denominations
are written. for
Welcome back DP :)
Its been pleasure having you.
Cheers
On 29 Jul 2013 22:47, De Premor d...@premor.net wrote:
just remember, that i also not yet introduce my self :(
then let me introduce my self
You can call me *De* *Premor* and i am working in Network and
Infrastucture Division at
Are the entire code only numerics, or are they alpha numeric?
On Mon, Jul 29, 2013 at 10:44 PM, Don Barton donaldb...@gmail.com wrote:
Greetings,
We have a scanner we use to scan a barcode for blood units for a hospital
into an Excel spreadsheet. The scanner reads the entire barcode, but we
Hi Sam,
When the barcode is scanned it reads in alphnumerics and symbols. The only
symbol we have to worry about is the = sign at the beginning. In the
example above I just asked about the 00 at the end. If I can get the
code for the 00, I should be able to figure out the code for the = at
the
Hey
You can do do with formula
=MID (A1, 2, LEN (A2)-3)
HTH//Cheers
On 29 Jul 2013 23:48, Don Barton donaldb...@gmail.com wrote:
Hi Sam,
When the barcode is scanned it reads in alphnumerics and symbols. The
only symbol we have to worry about is the = sign at the beginning. In the
example
try this code
Sub trunkit()
Dim Ctx As Range
'We use this method to get dynamic Record count in C Column
For Each Ctx In Range(C2: Cells(Range(C:C).Rows.Count,
3).End(xlUp).Address)
If Right(Ctx, 2) = 00 Then
'Replace = sign, from removed 00 string
vba, thanks for your suggestion, which will work fine in formula.
De Premor - the code works exactly as designed with our barcode scanner!
Our Blood Bank supervisor is impressed!
Thanks you so much for your quick reply and expert help.
Don
On Mon, Jul 29, 2013 at 12:37 PM, De Premor
Dear Experts,
I have attached my file, here different column double clicking and data should
paste in different columns, I have done only in one column and other is unable
to do. please co-operate me to complete my assignment.
Awaiting your positive response
Regards
Sajid Memon
Dear Experts,
I have attached my file, here different column double clicking and data should
paste in different columns, I have done only in one column and other is unable
to do. please co-operate me to complete my assignment.
Awaiting your positive response
Regards
Sajid Memon
32 matches
Mail list logo