assuming your data (one column range) are in A1:A100
and there are some 0 (blank / zero) value in these column..
try this *Array Formula*
=MIN(IF(A1:A1000,A1:A100))
On Wed, Mar 30, 2011 at 3:39 AM, John A. Smith johnasmit...@gmail.comwrote:
Thank you very much. It works great. One
can u send that file.
Divaker
On Tue, Mar 29, 2011 at 2:40 PM, Anil Bhange
anil.bha...@tatacommunications.com wrote:
Hi Expert,
Some of my excel sheet has linked with Internet which requires live auto
updation, by default I can do 1 min refresh…
Could you help me with any VB code
Hi expert
I have a software which show two diff. work sheet in one excel under
different tab.
If any one know that software please mail me the name.
Regards
Manhar Prajapati
--
--
Some important links for excel
this add in is not working
On Wed, Mar 30, 2011 at 10:42 AM, ashish koul koul.ash...@gmail.com wrote:
try this addin see if it helps
http://www.rondebruin.nl/mail/add-in.htm
On Tue, Mar 29, 2011 at 8:02 PM, shariq khan shariqcoo...@gmail.comwrote:
Can any one help me?
I looking
Really useful link.
Thanks Ashish
Thanks a lot.
On Wed, Mar 30, 2011 at 10:59 AM, ashish koul koul.ash...@gmail.com wrote:
Hi all
To learn advance access, excel ,word, powerpoint, outlook VBA coding
, open the weblink given below
http://www.mvps.org/links.html#VisualBasic
--
Hi All,
I need formula to update column C, value if the time is between 7:00 AM to
9:00 PM YES else NO
Find attached for the same.
Column AColumn BColumn C
DateTime (MST) 7:00 AM 9:00 PM
3/28/2011 6:26 AM YES IF
Sir,
Is it possible to select two criteria. In the given case Date and Room
number and then sort by date.
Regards,
C.G.Kumar
On Fri, Mar 25, 2011 at 8:55 PM, STDEV(i) setiyowati.d...@gmail.com wrote:
1.
formula HELPER
( creating list of RowIndex )
array formula in multi cells
Try this formula
=IF((B2=7/24)*(B2=9/24),NO,YES)
On Wed, Mar 30, 2011 at 6:53 PM, zinknax.zin...@gmail.com wrote:
Hi All,
I need formula to update column C, value if the time is between 7:00 AM to
9:00 PM YES else NO
Find attached for the same.
Column AColumn BColumn C
You can use this formula, make sure to change C6 to the cell your data
is located.
=IF(AND(C6TIMEVALUE(07:00),C6TIMEVALUE(17:00)),NO,YES)
On Mar 30, 7:53 am, zinknax.zin...@gmail.com wrote:
Hi All,
I need formula to update column C, value if the time is between 7:00 AM to
9:00 PM YES else
in excel 2003
use menu: Window New Window
and then: menu Window Arrange
On Wed, Mar 30, 2011 at 12:54 PM, manhar prajapati
prajapati.man...@gmail.com wrote:
Hi expert
I have a software which show two diff. work sheet in one excel under
different tab.
If any one know that software
Hi Manhar,
I am not sure about this. This must be some kind of windows arrangement.
Please attach a screen shot image of that screen, if possible so that
Group members can easily understand.
I am sure you are not confused with extra sheets in a workbook and you
must be knowing that we can add
Hi Nadine,
See the attached file where I have used the following formula to
achieve the desired result.
=IF(SUMPRODUCT((Sheet1!$A$2:$A$20=Sheet2!$A2)*(Sheet1!$B$2:$B$20=Sheet2!$B2)*1)=0,Not
Valid,Valid)
Please feel free to revert in case of any issues.
Best Regards,
DILIPandey
On 3/30/11,
Hi Manoj,
You can subscribe to this group by following the below link:-
http://groups.google.com/group/excel-macros
Alternatively, you an also send your joining request to the Manager /
Owner of the group (ayush jain jainayus...@gmail.com).
Best Regards,
DILIPandey
On 3/29/11, Manoj Kumar
Hi Manoj,
You can subscribe to this group by following the below link:-
http://groups.google.com/group/excel-macros
Alternatively, you an also send your joining request to the Manager /
Owner of the group (ayush jain jainayus...@gmail.com).
Best Regards,
DILIPandey
On 3/29/11, Manoj Kumar
Thanks Ashish...!!
This is awsome site.
Best Regards,
DILIPandey
On 3/30/11, ashish koul koul.ash...@gmail.com wrote:
Hi all
To learn advance access, excel ,word, powerpoint, outlook VBA coding
, open the weblink given below
http://www.mvps.org/links.html#VisualBasic
--
*Regards*
*
15 matches
Mail list logo