did this helped?
On Fri, Jul 25, 2014 at 6:44 PM, Vaibhav Joshi wrote:
> Hi
>
> Pl refer attachment, due to your data formula became complex, you can
> check example next to it for an explanation.
>
> Cheers!!
>
>
> On Fri, Jul 25, 2014 at 3:45 PM, bhanu prakash wrote:
>
>> Team,
>>
>> Any ex
Your Welcome..
On Sat, Jul 26, 2014 at 9:48 AM, Nur Hossain wrote:
> Hi Pramod da,
>
> It works perfectly , thanks for your supports
>
>
> On Sat, Jul 26, 2014 at 9:58 AM, Pramod Singh wrote:
> > H Nur,
> >
> > Your Formula will be
> >
> =IF(A1="Red","us2",IF(A1
Hi Pramod da,
It works perfectly , thanks for your supports
On Sat, Jul 26, 2014 at 9:58 AM, Pramod Singh wrote:
> H Nur,
>
> Your Formula will be
> =IF(A1="Red","us2",IF(A1="Sta","ru2",IF(A1="Ida","Cu2",IF(A1="Pco","Us3",IF(A1="Pde","Cu3","")
>
>
> Regards
> Pramod
>
>
> On Sat, Jul 26
H Nur,
Your Formula will be
=IF(A1="Red","us2",IF(A1="Sta","ru2",IF(A1="Ida","Cu2",IF(A1="Pco","Us3",IF(A1="Pde","Cu3","")
Regards
Pramod
On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain wrote:
> Dear all , how to merge following six formula into single formula.
> small formula is requir
Dear all , how to merge following six formula into single formula.
small formula is required . Thanks
IF(A1="red","us2","")
IF(A1="sta","ru2","")
IF(A1="ida","cu2","")
IF(A1="pco","us3","")
IF(A1="pid","ru3","")
IF(A1="pde","cu3","")
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
What do you mean by "nearest".
Closest without going over?
or nearest absolute?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ev
Hi
Welcome to the group..
Cheers!!
On Fri, Jul 25, 2014 at 5:09 PM, Renu Khandelwal
wrote:
> Hi Excel Group
> My name is Renu and I am looking job in MIS profile. I love to learn
> Excel, VBA, MS-Access, I want to increase my knowledge through with group
> discussion.
>
>
> On Saturday, June
Hi
Pl check this...
Cheers!!
On Fri, Jul 25, 2014 at 4:10 PM, Jocky Beta wrote:
> Hi All,
>
> Any hope regarding on this?
>
>
> On Friday, July 25, 2014, Jocky Beta wrote:
>
>> Hi vaibhav it will be ok for me if it will be highlited by colour ,
>>
>> Regards
>>
>> On Friday, July 25, 2014, V
I suspect that what you've provided is a data sample that may not be realistic.
Will the values in the "Reader" column actually SAY "In" and "Out"?
or are these clock rings from users?
and, the date/time for each "IN" ring is probably not the exact time for the
corresponding "OUT" ring.
I can w
Hi Paul,
Thanks for your response.
But here biggest challenge is FBC Value in DATA MATCH sheet ( Column E ) is
not exact match, we need to find the nearest # in SOURCE sheet & I need
that Lvl details..hope this will give you clear idea on what I am looking
for..
Please help
Regards, Bhanu
On
Hi Excel Group
My name is Renu and I am looking job in MIS profile. I love to learn Excel,
VBA, MS-Access, I want to increase my knowledge through with group
discussion.
On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote:
>
> Hey all new and current posters,
>
> Welcome to excel
It looks like you've already got it set up.
You're using column A in the Source sheet to concatenate the Group,month and
location.
you need to add the FBC value to this column, however you'll probably want to
round the FBC number to 2 decimal places:
=E3&B3&D3&Round(F3,2)
in your data match she
Hi All,
Any hope regarding on this?
On Friday, July 25, 2014, Jocky Beta wrote:
> Hi vaibhav it will be ok for me if it will be highlited by colour ,
>
> Regards
>
> On Friday, July 25, 2014, Vaibhav Joshi > wrote:
>
>> Don't you think there will be too much of pop ups, instead how about
>> hi
Team,
Any experts for help on below mentioned request..please help
Regards, Bhanu
On Fri, Jul 25, 2014 at 11:41 AM, bhanu prakash wrote:
> Hello Team,
>
> Hope everyone doing good.
>
> Had attached the excel sheet for reference
>
> in that Excel you will find 2 tabs - one is "SOURCE" and othe
Hi vaibhav it will be ok for me if it will be highlited by colour ,
Regards
On Friday, July 25, 2014, Vaibhav Joshi wrote:
> Don't you think there will be too much of pop ups, instead how about
> highlighting it with color?
>
> Cheers!!
>
>
> On Fri, Jul 25, 2014 at 11:56 AM, Jocky Beta > wro
Don't you think there will be too much of pop ups, instead how about
highlighting it with color?
Cheers!!
On Fri, Jul 25, 2014 at 11:56 AM, Jocky Beta wrote:
>
> Hi team,
>
> I need some help in creating macro for an excel sheet. I have worksheet in
> which 18 nos of in and out transaction ar
16 matches
Mail list logo
