I want to know about for what purpose you use dde. CAn you shareit
On Thu, Jul 9, 2009 at 1:01 AM, steve.bags...@itmetrics.com <
steve.bags...@itmetrics.com> wrote:
>
> I am using DDE to drive MS/Excel 2007 and would like to use SAVE.AS to
> save the active workbook as a .xls, i.e. in excel 2003
Hi
Been racking my brains for a few days but simply seem to have blanked out. I
have an excel file with the following headers.
Product|Version|Status|Date|Executive|Company Name|Contact|
Note: All the rows under the headers can be repeated multiple times. Filter
is an obvious method to get data
Array formulas are used to deal with ranges of cells:
If you have a range of cells, let's say A1:A10, each with a value of 1,
let's try to add cells equal to 1 :
=SUM((A1:A10=1)*1)
Will give a result of 1 (in fact only the first cell is considered).
If you enter the same formula with Ctrl+Shift+En
Thanks a lot Danial
I had almost bang my head on the wall in search of this!
This forum Rocks!
Can you let me know what for 'Ctrl+Shift+Enter' is used for.
Thanks again!
Kunal
On Jul 9, 4:34 pm, "Daniel" wrote:
> Hi,
>
> Array formulas (valídate with Ctrl+Shift+Enter).
>
> In C22 :
>
> =MIN
Dear members,
It is my pleasure to inform you that the prize of June month goes to
Mr. Upendra Singh who was the winner of week 26. The prize is 200
rupees or 4$. The winner of the month is selected from the weekly
winners of the month. The Weekly winners of June is as follows :
1) Week # 24 : H
lol... i tried that before and it didnt happen.. and after u replied
its working... thanks a lot... coz i assumed there must be another
shortcut...
again thanks...
On Jul 9, 11:54 am, vivek agrawal wrote:
> CTRL + ] - for trace dependents "use the closing bracket instead of
> opening br
Then, let's use macro :
Sub Test()
Dim X As Single
X = 10
If [Sheet1!A1] < X Then
[Sheet3!A1] = ""
[Sheet2!A1] = [Sheet1!A1]
Else
[Sheet2!A1] = ""
[Sheet3!A1] = [Sheet1!A1]
End If
End Sub
[Sheet1!A1] is equivalent to Sheets("Sheet1").Range("A1"
Hello Guys,
I have a problem and my mind is blocked so need your help here- I have 4
cells one below the other and the values specified in each cell is as
follows
cell A - 65
cell B - 15
cell C - 3
cell D - 17
Now the total of all the cell is 100. If I change the value of any cell say
I change
How about the following
=COUNTIF(A1:A8,A6) + COUNTIF(A1:A8,A7)
Akhilesh Kumar Karna
On Thu, Jul 9, 2009 at 4:35 PM, amresh kumar wrote:
> Hi Team,
>
> i want learn more of countif function.
>
> example
>
> City Delhi Mumbai Maharashtra
> Delhi Mumbai Delhi Mumbai =COUNTIF(
Hello Pooja
To track changes on a new work sheet kindly follow the steps given below.
1. Activate the Track Changes Feature.
2. Assume that the changes have been made and saved in the work book. After
changes have been made to the workbook, you can automatically create a new
worksheet that lists
Dear Amresh,
simple way is to calculate seprately for Mumbai & Delhi & then add it
COUNTIF(A1:A8,"=Mumbai")
COUNTIF(A1:A8,"=Delhi")
On Thu, Jul 9, 2009 at 1:05 PM, amresh kumar wrote:
> Hi Team,
>
> i want learn more of countif function.
>
> example
>
>City Delhi Mumbai Maharas
Hi,
If you are using office 2007 you can use "countifs" function else u can use
formula like below
=COUNTIF(A2:A8,"mumbai")+COUNTIF(A2:A8,"delhi")
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of amresh kumar
Sent: 09
Hi
A Simple I use for a single city count is using the formula
=COUNTIF(A3:A15,"Mumbai"), where A3:A15 are the cells where the City Names
are entered.
For Multiple City Counts, you can use
=COUNTIF(A3:A15,"Mumbai")+COUNTIF(A3:A15,"Delhi") again A3:A15 is the range
where the City Names are entered
Thanks vivek for your help. This is really very helpful.
Thanks & Regards,
Ramkrishna T. Padhi
On 7/8/09, vivek agrawal wrote:
>
> Hello RamKishna,
>
> Please find attached the xls file with working macro...
>
>
> You just need to select the range containing the sheet names and run the
> macro
Hi Team,
i want learn more of countif function.
example
City Delhi Mumbai Maharashtra
Delhi Mumbai Delhi Mumbai =COUNTIF(A1:A8,A6)
Now i want count of two city Delhi or Mumbai
please suggest me that count if support of multiple value.
--~--~-~--~~~
Just starting to learn macros.
I have a cell in Sheet1 that performs a calculation. Either by means
of a function in a cell, or with a macro, create a conditional that
will insert the calculated data into a cell in Sheet2 or Sheet3.
Example:
Calculation performed in Sheet1 A1.
Conditional
CTRL + ] - for trace dependents "use the closing bracket instead of
opening brackets"
Regards,
Vivek Agrawal
Contact No. +91--154-077
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Thu, Jul 9, 2009 at 11:29 AM, JD wrote:
>
> Can anyone tell me a sh
hi,
try this macro
Sub RemoveChar()
Dim StrAdd As String
StrAdd = Range("A5000").End(xlUp).Address
Range("A1").Select
While ActiveCell.Address <> StrAdd
If InStr(1, ActiveCell.Value, "*") > 0 Then
ActiveCell.Value = Right(ActiveCell.Value, Len
(ActiveCell.Value) - 1)
End If
18 matches
Mail list logo
