Hi C.G.,
Could you please elaborate more on what condition you would like to put in
here?
Regards,
Andy
On Fri, Oct 8, 2010 at 10:34 AM, C.G.Kumar wrote:
> I am looking for conditional sum i.e. sum based on criteria. But neither
> Sumproduct nor SUMIFS and Pivot serve the purpose.
>
> Attached
Dear Rajasekhar
Please use u Sumif Formulas.
Regards
Sumit Vyas
On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju <
rajasekhar.prahar...@gmail.com> wrote:
>
>
> hi Excel Guru,
>
>
> Please assist me in this concern .
>
>
> Attached are two sheets Task distribution orginal and other she
On Wed, Oct 6, 2010 at 10:41 AM, SUMIT VYAS wrote:
> Dear
>
> No Proper work
>
>
>
>
> On 10/5/10, Paul Schreiner wrote:
>>
>> funny!
>> Luckily, I haven't had any of my editors convert the
>> characters to smileys!
>>
>> It would make it VERY distracting.. although cheerful!
>>
>> Paul
>>
>>
>>
try this code it may help you.
Sub removeshadow()
Dim i As Integer
Dim sh As Shape
For i = 1 To Worksheets.Count
Sheets(i).Activate
For Each sh In ActiveSheet.Shapes
sh.Shadow.Visible = msoFalse
Next sh
Next i
End Sub
On Fri, Oct 8, 2010 at 4:54 AM, Jude Barnes wrote:
> Our company i
I am looking for conditional sum i.e. sum based on criteria. But neither
Sumproduct nor SUMIFS and Pivot serve the purpose.
Attached sample file . Hope you will be able to solve the crux.
Regards,
C.G.Kumar
--
--
Dear Arif,
No file is attached,
Regards,
Vijaykumar
On Thu, Oct 7, 2010 at 5:34 PM, arif massani wrote:
> THERE IS NO FILE ATTACHED
>
> On Thu, Oct 7, 2010 at 5:08 PM, santanu_ca wrote:
>
>> HI
>> I HYPERLINKES A SHEET WITH ANOTHER SHEET IN SAME WORK BOOK BUT IT
>> DOES'NT WORKS. FILE ATTACHE
Our company is new to Excel 2007. I have moderate experience in VBA.
When we converted to Excel 2007 from Excel 2000 we have a staff member
who suddenly found that 1000+ of her excel files for whatever reason
has a shadow effect on misc shapes in the excel files. Each of the
files has between 1 a
Hi,
I am copying / pasting data from another source to my excel sheet…That I can
do it manually no problem.
Now I would like to transpose that data and paste say sheet2..That can also
done manually, but the challenge is I need to copy and transpose only the
cells in the rightmost ( containing
Dear Friend,
Add-in in Excel is any tool (other than the normal available) ones which
does a specified activity i.e detecting and eliminating duplicates,finding
difference between dates etc, .it is a sfecfically written Macro or VBA
which performs specific tasks in an easy manner. you can get Exc
=sum(*Your_range*)/(COUNT(*Your_range*)-COUNTIF(*Your_range*,0))
On Thu, Oct 7, 2010 at 8:02 PM, Dilip Pandey wrote:
> Dear Mr. Rao,
>
> Please find the solved spreadsheet attached with this email. I have used
> SumProduct and Count functions to solve the query. Let me know if this
> helps :)
hello friend,
Go to top left hand corner of excel click on office button--> excel
options---> then select the add ins by double clicking on it.
then click on manage option ---> go
Thanks,
Raj
On Thu, Oct 7, 2010 at 10:55 PM, SAJID MEMON wrote:
> Hi Experts,
>
> I want to know Add-in in ex
Hi Experts,
I want to know Add-in in excel. How this option is working or how can i know
about this option much more.
Give me any idea or tips.
awaiting your replay
Regards
sajid memon
--
-
Paul,
Thank you so much for taking the time to find a solution for me. Unfortunately
the data cannot be sorted to make a formula in col H work. It's dependent on
another table which is then dependent on another. I really appreciate all the
time you took to try to find something that works fo
Have you tried looking at the "help" for these functions?
Do you understand functions at all?
As far as retrieving data from one sheet to another:
Let's say in sheet1, Cell A2 you want the value from Sheet2, Cell A2.
in Sheet1, you insert the "=" sign, then switch to sheet2 and select cell A2.
Th
Hi Everyone,
What is indirect Function and Address function and row function , column
Function . How Can we retrieve data from sheet 2 to sheet 1 using indirect
function . ?
Please explain It .
Thanks and Regards
--
Hi, I'm hoping someone can help me.
I'm trying to write a macro import data from a master spreadsheet held
on our LiveLink DMS.
It needs to autorun for any person opening the workbook on any
machine. I used to have it working when the master was held on a
normal groupdrive, but since the file h
Dear Mr. Rao,
Please find the solved spreadsheet attached with this email. I have used
SumProduct and Count functions to solve the query. Let me know if this
helps :)
Best Regards,
DILIPandey
On Fri, Oct 1, 2010 at 12:08 AM, NRao Mynampati
wrote:
> Hi experts,
> how to eleminate zeros while
>
> Hey,
Check this and Let me know.
> Sub del_br()
Dim coun As Long
With ActiveSheet
For coun = .Cells.SpecialCells(xlCellTypeLastCell).Row To 1 Step -1
If WorksheetFunction.CountA(.Rows(coun)) = 0 Then
ActiveSheet.Rows(coun).Delete
End If
Next
En
Hi
find required info on below link
http://www.vbaexpress.com/kb/getarticle.php?kb_id=395
On 10/7/10, Rajat Kapoor wrote:
>
> I wanted to know how can one delete all blank rows & columns using
> VBA? Suppose in Cell A1 there is data but in other cells with row 1
> there is no data. Thus we can s
That depends on if by: "the results I want" you mean the exact numbers you
gave as examples, then no, it may not.
However, if they're sorted by columns A/B/C & F,
then this MAY work for you:
I created a column "H" and inserted:
=A2&B2&C2&F2
then, in column "I":
=IF(NOT(ISNA(VLOOKUP(H2,H$1:I1,
I wanted to know how can one delete all blank rows & columns using
VBA? Suppose in Cell A1 there is data but in other cells with row 1
there is no data. Thus we can say this row is not blank. BUt taking
other example suppose there is data in Cell C1, A3, A4. But entire row
i.e ROW - 2 is blank. How
Attached sample file for the problem. Hope somebody among you will be able
to solve the crux.
Regards,
C.G.Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http
Attached sample file for the problem. Hope somebody among you will be able
to solve the crux.
Regards,
C.G.Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http
Hi everybody
I’ve a big trouble but maybe, for you is an easy trouble.
I’m working on excel2003.
I’ve to compare two values, in the same pivot table, using vlookup.
My problem is that, the table_array, must be dynamic.
Sometimes the range is: SheetTest!$Q$1:$R$10; other times, could be !$Q
$70:$R$
THERE IS NO FILE ATTACHED
On Thu, Oct 7, 2010 at 5:08 PM, santanu_ca wrote:
> HI
> I HYPERLINKES A SHEET WITH ANOTHER SHEET IN SAME WORK BOOK BUT IT
> DOES'NT WORKS. FILE ATTACHED.
> SANTANU
>
> --
>
> --
> Some impo
HI
I HYPERLINKES A SHEET WITH ANOTHER SHEET IN SAME WORK BOOK BUT IT
DOES'NT WORKS. FILE ATTACHED.
SANTANU
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitte
Dear,
Please send No Of Row
No Of Column
Sheet Name eg: Date / Name / No. 1-2-3 / product name
i make sure report.
Regards
Sumit Vyas
On Thu, Oct 7, 2010 at 4:26 PM, Kishan Reddy, K <
kishanreddy.kethire...@gmail.com> wrote:
> Mr Brain,
>
> A macro can be written such that
>
> 1. It wil
Mr Brain,
A macro can be written such that
1. It will copy certain number of rows (one page full) to another
sheet (example sheet2)
2. In sheet2 it will be formatted for printout (such that C/F, B/F,
Page header, Page footer etc.)
(counters will be maintained for page numbers, C/F, B/
F ..
Please check the sheet
Regards
On Thu, Oct 7, 2010 at 12:00 PM, Dean Brown wrote:
> I have several questions so if it's ok with you I'll ask then one at a
> time (that'll give me time to digest any answers).
>
> Ok, here's problem 1.
>
> I want the person using the spreadsheet to input a value i
or, another formula in A2
*=MATCH(TRUE,A1={"A","B","C","D","E"},0)*20-10*
*
*
***
*
On Thu, Oct 7, 2010 at 4:23 PM, siti Vi wrote:
> *formula in cell A2 *
> =CHOOSE(MATCH(TRUE,A1={"A","B","C","D","E"},0),10,30,50,70,90)
> *formula in cell A3*
> =A2+10
>
>
> On Thu, Oct 7, 2010 at 1:30 PM, Dean Br
*formula in cell A2 *
=CHOOSE(MATCH(TRUE,A1={"A","B","C","D","E"},0),10,30,50,70,90)
*formula in cell A3*
=A2+10
On Thu, Oct 7, 2010 at 1:30 PM, Dean Brown wrote:
> I have several questions so if it's ok with you I'll ask then one at a
> time (that'll give me time to digest any answers).
>
> Ok,
Hello ,
i mean i want to see to totals on custom footer.. like below excel
file.. i wrote "xxx" which place i want to write footer total.. my
intention.
that is file... ornek.xls i added it in the group files.
http://excel-macros.googlegroups.com/web/ornek.xls?gda=e7Xufj4o61zD5UnH__xR-dBifwHh
I have several questions so if it's ok with you I'll ask then one at a
time (that'll give me time to digest any answers).
Ok, here's problem 1.
I want the person using the spreadsheet to input a value into cell A1.
The value that is input is going to be either A,B,C,D or E. The values
of cells A2
33 matches
Mail list logo
