Its working fine. Thanks for the help.
Regards
Rajesh Agarwal
On Thursday, June 23, 2016 at 9:50:57 AM UTC+5:30, a.gowri wrote:
>
> you can try this,
>
> 1
> =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21,$A$2:$A$21,1)-1),$A$2:$A$21))
> 2
> =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21
Hi
Please lookup the below position and if you feel comfortable ,then please
send me your updated resume
Position: Project Manager
Location: Mountain View, CA
Duration: Contract
Customer: HCL America
Job Description :
Project management experience with hardware/ device development proc
I don't know of any event that triggers from a "paste" action,
and it may end up becoming too complex for your situation,but what I've done in
the past is:
Since Public variables maintain their values within the Excel instance, even
when macros are not running:
Use the SelectionChange event to st
Yes good solution
Thanks a lot .. God Bless you
On 23 June 2016 at 21:30, Shaw McAllan wrote:
>
> Hiya,
>
> Can't you just use an AutoFilter? That way you can hide empty rows (or
> show them) whenever you feel the need.
>
> Cheers,
> -S
>
>
> On Monday, 20 June 2016 18:11:30 UTC+1, big smile wr
Position: Backend (audit analyst /data analyst)
Location: Gurgaon
Duration: Long Term
EXP : 0-3 years
Salarys 15- 25 Salary per annum
Looking for 3-4 candidates
--
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
Hiya,
Can't you just use an AutoFilter? That way you can hide empty rows (or show
them) whenever you feel the need.
Cheers,
-S
On Monday, 20 June 2016 18:11:30 UTC+1, big smile wrote:
> Hello Friends
> This sheet is the calculation of Accident policy of New India Ass Co Ltd
> I have
Evening, All!
I've got a log working on my spreadsheet. So far it logs who (and when) the
workbook itself was opened, saved or closed. What I'd also like is to know
if someone pastes - or deletes - data from each individual sheet within the
workbook.
We update the spreadsheet monthly; initi
Hi,
Hope you doing Well !!!
Here is our *Implementing partner **Requirement*, Please go through the
below requirement and send us suitable consultant with their *updated
resume, rates and Contact details ..*
*Role: Technical Analyst (JD Edward) Location: **Fort Worth, TX*
*Work Duration: 6+
Hi All,
I am looking to copy paste data from one spreadsheet to another. In the
process, i do not want the users to update same rows multiple times.
I would require macro to identify the duplicate row (using a unique id) and
update the row. Sometimes there might be some changes and hence the lat
