files.
Thank you
with regards
raghu
On Mon, Feb 20, 2012 at 11:47 PM, raghu gr balaji.bra...@gmail.comwrote:
hi,
Thanks this is very good. thank you
with regards
raghu
On Mon, Feb 20, 2012 at 3:11 PM, xlstime xlst...@gmail.com wrote:
Hi Raghu,
you can use *Agent Ransack
very useful
On Wed, Feb 22, 2012 at 11:08 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Group,
I have shared a Custom Format example sheet, i got it from below link
http://spreadsheetpage.com/index.php/file/custom_number_formats/
Hope it will help to all of you.
--
Thanks
Hi Jitendraky,
Please find the below link for number to text convert macro coding
http://www.ozgrid.com/VBA/ValueToWords.htm
*Hi Group,
it is my suggestion that, before sending any query request you to kindly
try to Google it self.
*
On Thu, Feb 23, 2012 at 9:06 AM, jitendr...@gmail.com
Hi Joy,
please check below link..
http://www.mrexcel.com/archive/VBA/28261.html
On Fri, Feb 24, 2012 at 10:38 PM, Ms. Joy joypue...@gmail.com wrote:
Someone asked me if I knew how to make Excel dial a phone number???
Has anyone ever heard of this? How would I make this happen? Can
someone
you can use pivot table.
On Fri, Feb 24, 2012 at 4:58 PM, raghunandan rallapalli
raghunandan.rallapa...@gmail.com wrote:
Sir,
I mean, its a group wise, counting from FRA+STN wise ,, like in sql
(SELECT FRA,STN,COUNT(1) FROM COUNT GROUP BY FRA,STN
THANKS
WITH REGARDS.
RRN
On Fri, Feb
Hi Pankaj,
You can use Lookup function.
please find the example sheet.
On Sat, Feb 25, 2012 at 12:57 AM, Secret Shot secrets...@gmail.com wrote:
Dear group,
I want to make bucket of age like 0-2,2-4,4-6 etc.
However I can do this by if formula.
But that is very lanthy formula and also
which version you are using ?
On Sat, Feb 25, 2012 at 7:00 PM, raghu gr balaji.bra...@gmail.com wrote:
Hi xlstime,
its working for text only, but for numbers it is not working pls help.
with regards
raghu
On Wed, Feb 22, 2012 at 9:02 PM, xlstime xlst...@gmail.com wrote:
please use same
25, 2012 at 10:15 AM, Maries talk2mar...@gmail.com wrote:
Hi,
Try it..
*=VLOOKUP(A1,{0,0-2;3,2-4;5,4-6;7,6+},2,TRUE)*
**
*=LOOKUP(A1,{0;3;5;7},{0-2;2-4;4-6;6+})*
Regards,
MARIES.
On Fri, Feb 24, 2012 at 11:31 PM, xlstime xlst...@gmail.com wrote:
Hi Pankaj,
You can use Lookup
, Feb 25, 2012 at 9:32 PM, raghu gr balaji.bra...@gmail.com wrote:
hi,
i am using excel 2003 and number is stored in text only sir
thank you
On Sat, Feb 25, 2012 at 9:04 PM, xlstime xlst...@gmail.com wrote:
which version you are using ?
On Sat, Feb 25, 2012 at 7:00 PM, raghu gr balaji.bra
please find the attachment
On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
Dear sir,
plz download the attachment and help me...
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
you can use ActiveSheet.PivotTables(PivotTable1).ClearAllFilters
or
At the top of the window, on the Ribbon, click the *Options* tab under
*PivotTable
Tools*. In the *Actions* group, click *Clear*, and then click *Clear Filters
*. Be sure you really want to do this before you undo all your
as per your result requirement, you can use sumif function
http://www.techonthenet.com/excel/formulas/sumif.php
On Tue, Feb 28, 2012 at 11:54 PM, finos finos...@gmail.com wrote:
Dear groups
** **
How can take the multiple values from the database using vlookup formula
. can u guide
Hi Joseph,
use concatenate with text formula
=CONCATENATE(A2, ,TEXT(A3,0.00%))
On Wed, Feb 29, 2012 at 1:01 AM, joseph.cam...@gmail.com wrote:
Hi guys,
I am trying to concatenate two cells.
One cell ha absolute number whereas the other cell is a percentage.
For e.g.,
Cell A1 =
first install tally odbc driver then user odbc
for more information please find the below link
http://www.tally9.info/2009/10/connectivity-using-tally-erp9-using-htmlodbc-xml-and-synchronization/
On Wed, Feb 29, 2012 at 8:54 PM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Dear expert,
I
=IF(AND(AND(A2=126,A2=375),(B2=500)),10,0)
On Wed, Feb 29, 2012 at 10:57 PM, Jorge Marques leote.w...@gmail.comwrote:
Hi guys, i don´t know, how is this, my formula is wrong, if i change the
weight beyond the limits it keeps giving 10. how can i change this, i think
it´s simple, but i´m not
press F12 or save as
or please find the below link
http://dmcritchie.mvps.org/excel/backup.htm
On Sun, Mar 4, 2012 at 5:48 PM, raghu gr balaji.bra...@gmail.com wrote:
hi,
I want save same excel file in two locations (different folders) if ctrl+s
is pressed, so that there will be no need
use Google Insert Image option in G mail or you can use link a .gif file...
[image: Inline image 1]
On Mon, Mar 5, 2012 at 12:41 AM, rekha siri rekha.siri2...@gmail.comwrote:
hi Experts,
I Am excel trainer, just wanted to know how can we place this kind of
animation in mail for excel
.
On Mon, Mar 5, 2012 at 7:58 AM, xlstime xlst...@gmail.com wrote:
use Google Insert Image option in G mail or you can use link a .gif
file...
[image: Inline image 1]
On Mon, Mar 5, 2012 at 12:41 AM, rekha siri rekha.siri2...@gmail.comwrote:
hi Experts,
I Am excel trainer, just wanted
thnax noorain..
On Tue, Mar 6, 2012 at 12:09 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Group,
Please find Excel addins see if they are of any use to you
http://www.rondebruin.nl/mail/add-in.htm
http://www.cpearson.com/excel/xltools.htm
Hi Rushiraj,
you can also you lookup function please find the attachment..
On Wed, Mar 7, 2012 at 11:42 AM, Rushiraj Patel
rushiraj.pa...@in.aegisglobal.com wrote:
Dear Experts,
** **
I am using Excel 2003.
** **
I have a file in which I need to bifurcate the figures in
please send the sheet with example
On Tue, Mar 6, 2012 at 6:14 AM, sherif azat sherifazat...@hotmail.comwrote:
what i want in the sheet
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need
You can use Go To special function
On Fri, Mar 9, 2012 at 1:28 PM, Brian brianfosterbl...@gmail.com wrote:
In column a from row 4 to row 52 I have a list of numbers. however
some cells are empty. I need to remove the empty cells so that i
have a list of numbers from row 4 downwards with no
you can use paste special link function ..
On Mon, Mar 12, 2012 at 8:13 PM, chhajersand...@gmail.com wrote:
Dear Excel gurus,
I want to link my excel table which is in MS WORD as table with other MS
EXCEL file.
Can it be possible with any macros.
Sandeep Chhajer.
Sent on my BlackBerry®
Congrats noorain
On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Feb'12
He has posted 156 posts in Feb'12 and helped many people through his
expertise. He has been
Congratulation Dear Ayush and all group members
On Thu, Mar 22, 2012 at 4:25 AM, Ayush Jain jainayus...@gmail.com wrote:
Dear members,**
I am proud to announce that the forum has completed 5 years today. This is
really great milestone of the forum.
My sincere thanks to
Thanks Brother...and really superb
2012/3/23 NOORAIN ANSARI noorain.ans...@gmail.com
जहाँ Excel के दीवानों की, है बहूत घनी आबादी.
जहाँ Question,Answer करने की,है खूब आज़ादी.
जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया.
दोस्तों उस अपने Excel-Macro ग्रुप का
HI Vijay,
You can use very simple formula '=int(your date)
Int is basically use for Rounds a number down to the nearest integer.
On Thu, Apr 5, 2012 at 9:24 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi ,
12/2/2001 12:00 PM --- How to remove time ? i need only date .. is
what is this ??
On Sat, Apr 7, 2012 at 6:34 AM, Atef Gobran gobran...@yahoo.com wrote:
font size=7img src=
http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/39.gif;strong@@/strong
strongfont
style=BACKGROUND-COLOR:#ffbf80; face=comic sans ms color=#4040ffDr.
Atef Gobran/font/strong
great collection ...
On Sat, Apr 7, 2012 at 3:09 AM, Maries talk2mar...@gmail.com wrote:
Dear Friends,
I have accumulate the my collection for Excel. Please update, If you
anything more.
I hope these links are very useful everyone.
http://www.andrewsexceltips.net/
great collection ...
On Sat, Apr 7, 2012 at 3:09 AM, Maries talk2mar...@gmail.com wrote:
Dear Friends,
I have accumulate the my collection for Excel. Please update, If you
anything more.
I hope these links are very useful everyone.
http://www.andrewsexceltips.net/
you can use
=LEFT(A2,FIND( ,A2,1)-1) for before space and
=right(a2,len(a2)-len(LEFT(A2,FIND( ,A2,1))
) after space
On Fri, Apr 6, 2012 at 4:36 PM, Veeru TOC veerub...@gmail.com wrote:
Dear Sir, its working fine
anothe one i need after space data in next cell
example
vanam
Congratulation Rajan
On Wed, May 2, 2012 at 9:30 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
April'2012
He has posted 185 posts in April 2012 and helped many people through his
expertise. He has been
Congratulations Rajan
On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
May'2012
He has posted 147 posts in May 2012 and helped many people through his
expertise.
I truly
excel 2007 not support VBA coding so save ur in excel 2003 or xlsb
On Mon, Oct 24, 2011 at 5:44 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Dear Noorain,
when I am saving your file it shows the attached error. please suggest.
Regards,
Aamir Shahzad
On Mon, Oct 24, 2011 at 5:03 PM,
Haseeb, why u use int or mod function ? pleas tell me
On Wed, Oct 26, 2011 at 12:35 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello Murali;
You can also use INDEX with INT MOD
see the attached
HTH
Haseeb
--
Sorry Sam you are completely ,
i mean excel 2007 (Excel workbook not support vba) so save ur file in excel
2003 or excel macro enable 2007 format
On Mon, Oct 24, 2011 at 5:44 PM, Aamir Shahzad
aamirshahza...@gmail.comwrote:
Dear Noorain,
when I am saving your file it
Happy Diwali to all.
On Wed, Oct 26, 2011 at 5:51 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Members,
WISH YOU A HAPPY DIWALI.
ALL THE BEST
Regards,
Sanjib
--
--
Some
try consolidate pivot table option..
http://tipsindeed.com/excel/data-consolidation-in-excel-made-easy-using-pivot-tables.html
On Thu, Oct 27, 2011 at 4:40 PM, airen airen1...@gmail.com wrote:
Hi Noorain,
Thanks for your reply. Provided solution wont work, I dont want empty
rows in
mind blowing Haseeb,
On Sat, Oct 29, 2011 at 5:52 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello XLS S;
Let me try to explain my best :)
In sheet2 B1, used a formula to get all items in sheet1, which is
=COUNTA(Source!A3:Z65536)
B2, used too get total columns used, which
try this..
=(YEAR(C3)-YEAR(B3))*12+(MONTH(C3)-MONTH(B3))+((DAY(C3)-DAY(B3))/30)
On Sat, Oct 29, 2011 at 9:47 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Here's a more accurate formula, though longer
Great ..very simple and easy
On Sun, Oct 30, 2011 at 7:10 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Group,
Please find attached Simple Excel Calender.
=TRANSPOSE({1;2;3;4;5;6;7})
Congrats Sam and
*
*
*Don Guillett, Noorain, Ashish, Dilipandey, Rajan , Aamir, Hasib ,
shaneallen *
On Thu, Nov 3, 2011 at 5:57 AM, Asa Rossoff a...@lovetour.info wrote:
Congrats Sam!
** **
Lots of generous effort on your behalf.
** **
Asa
** **
*From:*
Please find the attachment..
On Fri, Nov 4, 2011 at 6:53 PM, rvsingh parmar
rvparmar.sing...@gmail.comwrote:
Dear,EXCELERS
On this workbook i want in summary sheet* fill total gift given
coloum*according their given dates Valus in second sheet (gift data),, by
any
formula . So
try this ..
http://www.contextures.com/xladvfilter01.html
On Sun, Nov 6, 2011 at 4:54 PM, chhajersand...@gmail.com wrote:
Hi Rohan,
I have tried now the same but it only giving me the column labels as
output.
Don't know what to do.
Sandeep Kumar Chhajer.
Sent on my BlackBerryŽ from
hi chandra,
please find the below code for remove module ..
http://www.ozgrid.com/VBA/delete-module.htm
Sub DeleteThisModule()
Dim vbCom As Object
Set vbCom = Application.VBE.ActiveVBProject.VBComponents
vbCom.Remove VBComponent:= _
vbCom.Item(Module1)
End Sub
On Tue, Nov
Hi Amit,
it's not possible to put unique value in pivot table. u need to create
extra column.
*Team Excel*
On Sun, Jan 8, 2012 at 11:10 PM, Mahesh parab mahes...@gmail.com wrote:
Hi Amit
find attach workbook. hope this will help
Add one column in your pivot table data use below formula
Hi Friend,
as per my observation, please find the attachment
Team
XLS
On Fri, Jan 13, 2012 at 8:37 PM, Jorge Marques leote.w...@gmail.com wrote:
Hi guys, i´m doing a excel file for comparatives of the year 2010, 2011,
2012, the problem is that i need to compare days, like if i choose to see
for which type process like inbound or outbound
On Thu, Jan 12, 2012 at 4:29 PM, hemanath dhanasekar hema5s...@gmail.comwrote:
Hey Friends,
I am Hemanath working in a Leading BPO as Team Leader, I am new to this
industry and I need your help folks
Can anyone help me in sharing the SLA and
Dear Aamir,
very simple 13 mean 1 pm and 14 mean 2 pm
but as per your example sheet you should need to replace 14 to 15..
because 15 mean 3 to 3
On Fri, Jan 13, 2012 at 10:46 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Dear Maries/Anjul Porwal,
Why tou use 13 in your formula. can
Hi Santosh,
yes it is possible, please find the attachment
On Sat, Jan 14, 2012 at 4:56 PM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hi Group,
Is it possible to show a statement moving from right to left in MS Excel
that we usually see in websites or in our system screen
?
If you cannot explain EXACTLY what you want, WHERE you want and HOW
you
want, it will be very difficult for volunteers to help.
Sam
--
Sam Mathai Chacko
xlstime xlst...@gmail.com Jan 15 09:27PM +0530
Hi Vivek,
new page mean new report or page for each dealer
use AutoReport: Columnar wizard
On Mon, Jan 16, 2012 at 12:52 PM, vivek vivek.j...@gmail.com wrote:
I tried to prepare the report in Access . But the problem is that the
schemes details do not display vertically as required. They are displayed
horizontally. The number of schemes is about 100
what you want?
On Tue, Jan 17, 2012 at 12:46 PM, Neeraj Chauhan neerajchauhan...@gmail.com
wrote:
Dear All
The correct sheet attachd
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent,
this are the temp files..not possible to UNHIDE but try to use *attrib -s
-h -r* in cmd
use:-
press window+r button for run then type cmd and then type atrib -s -h -r
then enter
On Fri, Jan 20, 2012 at 12:29 PM, Neeraj Chauhan neerajchauhan...@gmail.com
wrote:
Dear sir,
** **
Hi Ashish,
use this formula (if you date format is same 20120121 )
*=DATEVALUE(CONCATENATE(LEFT(B2,4),-,MID(B2,5,2),-,RIGHT(B2,2)))*
On Sat, Jan 21, 2012 at 9:50 AM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Dear experts,
I want to change date format from 20120121 or 21012012 to
or try this one.. for any format
=TEXT(B2,-00-00)+0
On Sat, Jan 21, 2012 at 10:14 AM, xlstime xlst...@gmail.com wrote:
Hi Ashish,
use this formula (if you date format is same 20120121 )
*=DATEVALUE(CONCATENATE(LEFT(B2,4),-,MID(B2,5,2),-,RIGHT(B2,2)))*
On Sat, Jan 21, 2012 at 9:50 AM
.
On Sat, Jan 21, 2012 at 10:29 AM, chandra sekaran
duraichan...@gmail.comwrote:
try this
=TEXT(TEXT(B3,-00-00),DD-MM-)
chandru
On Sat, Jan 21, 2012 at 10:16 AM, xlstime xlst...@gmail.com wrote:
or try this one.. for any format
=TEXT(B2,-00-00)+0
On Sat, Jan 21, 2012 at 10
for excel 2003
=IF(ISERROR((ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7=Months,(F7/12),IF(E7=Years,F7,F7/365))),2))),,(ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7=Months,(F7/12),IF(E7=Years,F7,F7/365))),2)))
On Sun, Jan 22, 2012 at 10:37 AM, Nikhil Shah nikhil201...@gmail.comwrote:
Hi sam,
Can you post
Hi Kaushi,
please find the below link.
http://www.mrexcel.com/tip107.shtml
On Sun, Jan 22, 2012 at 3:58 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi,
How to convert pdf file to excel without any pdf converters?
regards,
Kaushik Savla
--
FORUM RULES (986+ members already BANNED
Dear Yasir,
Please find the attachment ..
formula : - =(INT(D3)+E3)-(INT(B3)+C3)
On Sat, Jan 28, 2012 at 12:42 PM, yasir_shahjee yasir.shah...@gmail.comwrote:
Respected Masters,
Kindly check attached sheet. i need Time calculate in Hours. hopefully its
really easier for Masters.
thanks
HI Sajid,
just right click in any excel sheet and go properties
then change open with - click to change button
then program file folder in (c drive) then Microsoft office folder then
microsoft office2003 or office11 folder then select excel.exe then ok
HI
On Sun, Jan 29, 2012 at 1:25 PM,
Congratulation Brother !!
On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Jan'12
He has posted 175 posts in Jan'12 and helped many people through his
Hi,
please find the attachment..
On Tue, Jan 31, 2012 at 8:32 PM, Veeru TOC veerub...@gmail.com wrote:
Dear All,
Can i use pivot table up to data came below type but i required this type
of data
Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains
Fail 12:14:59
Hi Nemi,
Check your group membership setting ( go to edit my membership (*
https://groups.google.com/group/excel-macros/subscribe?hl=en*
))...
and your second question i think it is sheet calculation problem please
send the example
On Sun, Feb 5, 2012 at 11:59 AM,
Hi Pascal,
Check your group membership setting ( go to edit my membership (*
https://groups.google.com/group/excel-macros/subscribe?hl=en*
))...
On Thu, Feb 2, 2012 at 3:18 AM, Pascal Baro bpascal...@gmail.com wrote:
Hi,
I'm not receiving mail summary from group posting
Hi,
use short key for refresh all pivot tables in workbook
press crtl+alt+f5
On 2/11/12, Maries talk2mar...@gmail.com wrote:
Hi,
Try this code:
Sub AllWorkbookPivots()
Dim pt As PivotTable
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
For Each pt In
Hi ROhan,
Please find below links
http://www.howtogeek.com/howto/16386/find-office-2003-commands-in-office-2010/
http://office.microsoft.com/asstvid.aspx?type=flashassetid=XT010149329vwidth=1044vheight=788
On Fri, Feb 10, 2012 at 10:36 PM, Rohan bittu.ro...@gmail.com wrote:
Hi Group,
Could
Maries,
that's great.thnx
On Wed, Feb 8, 2012 at 4:11 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear Maries,
** **
This one was nice...can you please also provide us the solution for it?***
*
** **
Best Regards,
Amit
** **
*From:*
Dear Group,
I need HR MIS Report format Daily/Monthly/Yearly bases..
Thnx
Sunny
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
Hi Amit,
iMacros is the *only* software that can *automate both Internet Explorer
and Firefox.* You can control both web browsers directly from
Excel.*iMacros works with every website
*and can automate even the most complicated websites that use dialog boxes,
frames, Javascript and AJAX can be
if i am not wrong u can use CALL macro function
On Mon, Feb 20, 2012 at 12:44 PM, Mohammed Muneer mmun...@ccc.com.qawrote:
How to merge the Multiple Macro’s in single program?
My question is little jovial – but still it is trying to learn some thing
from u masters. Thanx
Hi Mohammed Muneer,
you must be use proper subject line or Use concise, accurate thread titles.
for get quick attention or answered.
On Mon, Feb 20, 2012 at 12:22 PM, Mohammed Muneer mmun...@ccc.com.qawrote:
How to merge the Multiple Macro’s in single program?
** **
** **
**
Hi Prasad,
you can use *Advance Filter* function with macro recording .
for learn advance filer
http://www.contextures.com/xladvfilter01.html
On Sun, Feb 19, 2012 at 9:19 PM, Prasad Gadgil maocca1...@gmail.com wrote:
*Dear Friends,*
I am having data in master sheet wish to
Hi Raghu,
you can use *Agent Ransack * searching software
http://mythicsoft.com/page.aspx?type=agentransackpage=home
On Sun, Feb 19, 2012 at 11:41 PM, raghu gr balaji.bra...@gmail.com wrote:
Sir,
Sir some error in line,
Set a = wk.Cells.Find(What:=* ThisWorkbook.Sheets(File
Hi Amar,
Please find the attached solution
Rgds,
XLS
On Thu, Jul 19, 2012 at 6:32 PM, amar takale amartak...@gmail.com wrote:
Sir
But if student fail Then who is second highest will calculate first Rank
automatically.
Thanks
On Thu, Jul 19, 2012 at 6:28 PM, NOORAIN ANSARI
PFA THE ATTACHED MAY BE SOLUTION
On Tue, Jul 31, 2012 at 11:35 PM, Ashish kumar kumar.ashish...@gmail.comwrote:
Dear Champs,
I need to consider the time difference between both the countries. I want
to calculate the overall time consumed for the dispatch to be delivered,
kindly find the
In Excel, the *Areas* function returns the number of ranges in a reference.
The syntax for the *Areas* function is:
Areas( reference )
*reference* is a range of cells. If you specify more than one range, you
must surround your ranges with brackets.
For Example:
Let's take a look at an example:
WORKDAY
Returns a number that represents a date that is the indicated number of
working days before or after a date (the starting date). Working days
exclude weekends and any dates identified as holidays. Use WORKDAY to
exclude weekends or holidays when you calculate invoice due dates, expected
Congratulation Noorain Bhai
On Sat, Aug 4, 2012 at 12:53 AM, resp...@gmail.com wrote:
**
Congrats Boss. Keep up the momentum
Sent from my BlackBerry® smartphone from Airtel Ghana
--
*From: * Ayush Jain jainayus...@gmail.com
*Sender: *
use odbc connection for export and import data from access to excel
On Fri, Aug 3, 2012 at 6:08 PM, wirelesscellularguy
wirelesscellular...@gmail.com wrote:
On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
Hi All,
I am trying to relate Access data queries to
please explain some more..
On Fri, Aug 3, 2012 at 11:39 AM, Kenil Gala keni...@yahoo.com wrote:
hi folks,
i am having a query in getting external data,
pls help me for the same.
i have written my query in the excel sheet.
Thanks in adv,
Regards,
--
FORUM RULES (986+ members already
Dear All,
Good morning to all !!!
Can you send me the Business analyst tools or helping book/material for
learn about Business analyst
Thanks in advance
Regards,
XLS S
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already
Congratulations Noorain
On Sun, Sep 2, 2012 at 10:32 AM, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
Once again, Noorain Ansari has been selected as 'Most Helpful Member' for
the month of Aug'12. He has posted 111 posts in August 2012 and helped many
forum members through
Please search in below link
http://www.citehr.com/48781-how-make-hr-mis.html
On Sat, Sep 15, 2012 at 8:22 AM, kannan excel kannan.ex...@gmail.comwrote:
Hi friends,
i need mis report format for hr purpose. kly help me urgent base.
regards
kannan v
--
Join official facebook page
that's great but it's not working !!!
On Thu, Oct 4, 2012 at 4:13 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
How many Sheets this workbook have ?
do you remember all worksheet name?
you can write formual to recover the contain only but not formating
Congratulations Mr. Rajan Ji
On Wed, Oct 3, 2012 at 5:13 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
I can say only...
यूँ ही बरकरार रखो भाई अपने Expertise के छाप को.
और अपनी तरक्की से छोटा कर दो आसमा के माप को.
हम दोस्तों की दुआए,सदा संग बन के रहे साए...
मेरे ओर से
Yes, it is possible.. pls try Recognize txet from OCR
On Fri, Nov 30, 2012 at 2:16 AM, hanumant shinde arsfan2...@yahoo.co.inwrote:
Hi,
Is it possible to capture (scrape) data from .doc file but the data on
this .doc file is pasted as image.
--
Join official Facebook page of this forum
if u are using 2010 then you can use NETWORKDAYS.INTL
other wise
use sumproduct (=(G2-F2)-SUMPRODUCT((HOliday=F2)*(HOliday=G2)))
holiday list as per your requirement
Thanks
XLS S
On Thu, Jan 24, 2013 at 3:19 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear All,
** **
For a
please explain some more
On Thu, Jan 24, 2013 at 9:30 AM, Shiva Prasad shivaprasad1...@gmail.comwrote:
hi champs,
i have one main sheet some data sheet,
i need two dates with time between the the formula retrive the main sheet
based on Name colum in yellow color hilighted
pl z fin
use sumproduct function... please check my recent email solution
.
On Thu, Jan 24, 2013 at 1:55 AM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear Friends,
** **
I need your help
** **
Refer attached file,
**1) **“Detail” sheet contains handover details of
use sumproduct (=(G2-F2)-SUMPRODUCT((HOliday=F2)*(HOliday=G2)))
holiday list as per your requirement
On Mon, Jan 28, 2013 at 12:36 PM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
Dear Masters,
** **
Could you all, please reply.
** **
Best Regards,
Amit Desai
nooran ji good one thanks
On Mon, Feb 25, 2013 at 1:44 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Harkesh,
Please try it..
Function special_Charcters(rng As Excel.Range)
Dim i As Integer
Dim j As Integer
For i = 1 To Len(rng)
If Not Mid(rng, i, 1) Like [0-9,A-Z,a-z] Then
Hi Venkat,
try to use Sumif with index match function
=SUMIF($A$2:$A$7,F9,INDEX($A$1:$C$7,,MATCH($F8,$A$1:$C$1,0)))
Thanks
Team XLS
On Fri, Mar 1, 2013 at 7:20 AM, Venkat CV venkat1@gmail.com wrote:
Hello Everyone,
I have enclosed sample file were i required formula assistance If I
Hi Santosh,
u can try sumproduct with min or max
try this
=SUMPRODUCT(MIN((A2:A10=Criteria1)*(B2:B10=Criteria2)*(C2:C10)))
On Fri, Mar 1, 2013 at 1:11 AM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hello Group,
Need a small help on how to calculate the max with two or more
try this
=HYPERLINK(#ADDRESS(7,5,1,1,sheet2),lik)
On Fri, Mar 1, 2013 at 10:36 AM, amar takale amartak...@gmail.com wrote:
Dear All Friends
Thanks a lot everybody who give time for my solution.
Regards
Amar
On Fri, Mar 1, 2013 at 9:33 AM, The Viper viper@gmail.com wrote:
I don't
Hi,
PFA
Thanks
Team XLS
On Sun, Mar 3, 2013 at 12:52 AM, artforart artforart artforart...@gmail.com
wrote:
Hello
I have attached file
http://www.sendspace.com/file/wjh0oe
I want to automated a some step (tab table Z)
Thus, for example, that in X 2012:
1) I want to copy D16:E16
2)
why using macro?... just select hole column and change format
Regards,
Team XLS
On Mon, Mar 4, 2013 at 11:21 AM, Prashant Pawle ppawle.ex...@gmail.comwrote:
Dear Team,
Please amend macro in attached sheet to automatically select range based
on cell value.
Thx in advance
Regards,
Hi Amar,
i thik it is possible. but in another cell using Indirect,index and match
formula
Thanks
Team XLS
On Mon, Mar 4, 2013 at 11:50 AM, amar takale amartak...@gmail.com wrote:
Dear Experts Team
I have small query in excel,i give detail information in Attached sheet
Pls sloved my query
try this
http://www.free-training-tutorial.com/
On Mon, Mar 4, 2013 at 8:35 PM, Indrajit $nai talk2indra...@gmail.comwrote:
Hi all,
please provide me some basic training materials of Excel .
thanks in advance.
--
Indrajit
talk2indra...@gmail.com
Disclaimer:
This electronic message
Hi Shaikh,
something is missing in your data
what is the mean of Column D (% (On+Off Rte)) ... i thing Column A (Call
Pln) + Column B(Prod (On Rte))
if yes then put formula in column d = A2/C2
Enjoy
Team XLS
On Tue, Mar 5, 2013 at 4:01 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote:
1 - 100 of 254 matches
Mail list logo
