hi
I would like to add a couple of empty rows at the end of each grouping
in a spreadsheet. i.e instead of adding any subtotals, i would like to
keep two rows empty at the end of each grouping. The data in the
spreadsheet is divided into to groups. i donot want to add or count
any rows at the end
HI
Dose any one have pop up calender in excel cell.
Regards,
Prashant.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free a
Hi Shimmy,
As per my understanding, a pre-defined formulation can take care of your
worries, but for that you should provide us the test file. Please reply to
this email with the attachment and our "Group" will take care of that.
Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile:
Hi Pradeep (Deep)
Attached workbook has the scenario provided by you along with two possible
solutions based on "identiying the rows" and "coloring of the rows".
Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 1
*please provide a sample file*
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Wed, Sep 16, 2009 at 7:44 PM, Deep wrote:
> Dear Freinds,
> I am attaching one file which contains debit & credit
> amounts in same column. But previous column have D or C writ
Thanks Paul for your help!
I fixed the problem only putting "Application.Calculation =
xlCalculationManual" in the begin of the procedure.
Now, I'll try your suggestion..
Best Regards
Paulo
--~--~-~--~~~---~--~~
-
hi,
here u can use counta() in ur formulae with indirect function.
for example, if u have 10 entries in colomn B in Sheet1. Then for the range
1:10 w can have formulae
Indirect("sheet1'$B$1:$B$"&Counta(sheet1'$B$1:$B$500)) """
U can use in this manner. Sorry, if the solution is not
Dear Freinds,
I am attaching one file which contains debit & credit
amounts in same column. But previous column have D or C written which
represents the amount is Debit or Credit [D for debit & C for Credit]
I want to nullify {neutralise} if debit & credi
Please provide a sample file with example...
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Wed, Sep 16, 2009 at 3:27 PM, Shimmy wrote:
>
> Hi, I have data in sheet1 showing Name, gender, Place of residence and
> period of employment as respective columns. The problem is
Thanks Jiju, no need of cake, ur one line of gratitude is more than enough
to make my day.
But one suggestion from me, always go for the toughest solutions as* "Smooth
roads never make good drivers".*
*
*
Happy learning...
* *Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
Hi, I have data in sheet1 showing Name, gender, Place of residence and
period of employment as respective columns. The problem is I havae
only entered up to 30 entries as rows. In sheet two, I have my
commands for COUNTS for gender and the other commands; At the end of
my projects I must have 100
Hi prashant,
Thankyou for your suggestion.
I think next time, I have to use pivot tables rather than a formula.
I'm just at a beginner and recreating such complex formulas like
harmeetji's would be tough for me.
Thankyou guys-
--~--~-~--~~~---~--~~
---
Hi Harmeet Sir,
Thankyou so much for all your efforts.
Chocolate kya sirji, your deserve a cake for this---
Thanks
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1
Dude,
Go For Advanced Filter.
On Wed, Sep 16, 2009 at 12:51 PM, Aligahk06 wrote:
> Dear All,
>
> I want to fetch unique records through Formula or VBA.
> I have two records in two different column.I want to fetch Unique records
> from both the Column.
> E.g
>
> Col k10:k25 Col L10:L25
>
Dear All,
I want to fetch unique records through Formula or VBA.
I have two records in two different column.I want to fetch Unique records
from both the Column.
E.g
Col k10:k25 Col L10:L25
Rstyv 1"50 2.5
Rstyv 2"50 3.5
Rstyv 1"50 2.5
Rstyz 3"50 8.5
Rstyv 2"50 3.5
15 matches
Mail list logo
