What is the lookup value
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajesh Agarwal
Sent: Tuesday, December 17, 2013 5:34 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ vlookup query
--
Rajesh Kumar Agarwal
9811063001
--
Please forum members don’t pay attention on this totally fraud……….mail….
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Basole
Sent: Tuesday, December 17, 2013 7:15 PM
To: excel-macros@googlegroups.com
Cc: philip...@yahoo.com
Subject: $$Excel-Macros$$
-Macros$$ folder check
Hi Ravinder,
I have multiple folders with different folder names.(main folder), each main
folder having multiple sub folders with different names and each sub folder
having multiple workbooks. Workbooks are having different worksheet names.
These reports are Automated
May be you r looking for this. =IF(AND(A9A8,A90),A9,B8)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajesh Agarwal
Sent: Monday, December 16, 2013 4:01 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ formula query
--
Rajesh
I think u r looking for this.
=IF(B2=Platinum,INT(C2/3),IF(B2=Gold,INT(C2/12000),IF(B2=Silver,IN
T(C2/6000
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shaikh Iqbal
Sent: Friday, December 13, 2013 4:07 PM
To: excel-macros@googlegroups.com
YES
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shaikh Iqbal
Sent: Friday, December 13, 2013 4:38 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need - formula help
Ravinder,
is it correct
=IF(B2=Platinum,INT(C2/3
PFA, may be helpful for you, first select path where you want to save file.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pmyk
Sent: Friday, December 13, 2013 4:58 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Please Help
Try
give some examples
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of B.N.Chethan Kumar
Sent: Monday, December 09, 2013 6:13 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ VBA to send excel file using outlook
I have to send excel as
It made using macro..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pravin Gunjal
Sent: Saturday, December 07, 2013 11:19 AM
To: excel-macros@googlegroups.com
Subject: Fwd: $$Excel-Macros$$ Re: I appreciate your help :-)
Dear Ravinder,
It's
PFA, IF OK.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of TIWARI
Sent: Saturday, November 30, 2013 4:27 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ urgent need solution
Dear Sir,
I am attaching a file . We need a totally in file
Try this coding for hide the sheet. this will not allow to unhide from
excel, only can unhide using vba coding
Sub hidesheet_()
ThisWorkbook.Sheets(1).Visible = xlVeryHidden
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ali Abbas
Sent:
Pls share file and website from where you are picking values if possible
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anoop kumar
Sent: Wednesday, November 27, 2013 6:56 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Want help in
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajesh Agarwal
Sent: Wednesday, November 27, 2013 3:14 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ conditional formatting
Dear Friend
How to put conditional formatting in column
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anon
Sent: Wednesday, November 27, 2013 2:45 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Conditional Formatting
Attached.
On Tuesday, 26 November 2013 18:06:00 UTC, ashish
=DAY(B2)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dhaval Shah ( Ahd )
Sent: Thursday, November 28, 2013 5:44 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need formula help
Want to choss Day only from date pls refer
Pfa examples file
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Desai (MERU)
Sent: Thursday, November 28, 2013 10:49 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Column Reference to change when we move to
next row
Can
Pfa.
Button 1 is for getting the all files names in excel from a specific folder.
Button 2 is for rename the files from A to C column values.
You can put name manually also in column a and then use rename(2) button or
get all files from specific folder then put new name in column B if you
Pfa..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: Thursday, November 28, 2013 11:53 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Comments
Waiting for Reply
On Wed, Nov 27, 2013 at 2:18 PM,
U wants download pdf file form outlook account or you have saved thses files
in a folder and then need to open and save in a specific folder
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: Monday, November 25, 2013 1:25 PM
To:
Pfa.put coloumn name 1 and 2 like A for first column and b is for second
coloumn
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Santy
Sent: Thursday, November 21, 2013 10:56 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Scurb two columns
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: Wednesday, November 20, 2013 5:11 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup query
Dear All
Please find attached query.
Is it possible to write
at 5:19 PM, Ravinder ravinderexcelgr...@gmail.com
wrote:
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: Wednesday, November 20, 2013 5:11 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup query
Dear
Sheets(New).Select
On Error Resume Next
For i = 2 To ActiveSheet.UsedRange.Rows.Count
If Cells(i, 14) 25 Then
Cells(i, 16) = 2
Endif
If cells(I,14)25 then
Cells(i,16)=5
Endif
next
From: excel-macros@googlegroups.com
=(INDEX($A$1:$A$51,SMALL(IF(($G2=$B$2:$B$51)*(K$1=$D$2:$D$51)*ROW($B$2:$B$51
)0,ROW($A$2:$A$51)),COLUMN($A$1
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajan sharma
Sent: Monday, November 11, 2013 3:42 PM
To: excel-macros@googlegroups.com
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajan sharma
Sent: Monday, November 11, 2013 3:42 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Formula Error
Dear experts,
I have wrote formula in the attached file, but
Hi
Please help me, to create a formula with small function and Vlook up
function.
Regards
Ravindra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bill Q
Sent: Sunday, November 10, 2013 10:55 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup - Price List
Hi Guys,
This seems simple and I am pretty certain that it is -
PM
To: excel-macros@googlegroups.com
Cc: 'Soum'; Soum
Subject: Re: $$Excel-Macros$$ How to retrieve multiple or single data from a
single column like (A1) to different required columns like (D1, D2, D3
.)
Dear Ravinder Sory there is only one problem in my worksheet which i have
mentioned
Pfa, try this one.. if help you
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Hilary Lomotey
Sent: Tuesday, November 05, 2013 10:48 PM
To: excel-macros
Subject: $$Excel-Macros$$ Advanced Filter Not Working Properly
Hello Experts,
i need your
Could you pls give small data and your query and desired output with
calculation.so we can try
From: Kashan Abbas [mailto:kashanabbas...@hotmail.com]
Sent: Thursday, November 07, 2013 10:36 AM
To: excel-macros@googlegroups.com; xlst...@gmail.com;
ravinderexcelgr...@gmail.com
Subject: FW:
Pfa, I think you r looking for this..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Hilary Lomotey
Sent: Thursday, November 07, 2013 12:39 AM
To: excel-macros
Subject: $$Excel-Macros$$ loop to copy items one by one
Hello Experts,
i need
I think problem with yello highlighted color code. Pls try this if help
(PFA)
Sub RoundedRectangle1_Click()
Dim rng As Range
Sheet2.Range(a1:a9).Select
Set rng = Selection.Find(What:=b, After:=Range(a1), LookIn:=xlFormulas,
_
LookAt:=xlPart, SearchOrder:=xlByRows,
PFA, r u looking for this...?
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Nemi Gandhi
Sent: Tuesday, November 05, 2013 11:23 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Querry-serial no
A excel sheet is
PFA with two solution, if you are looking for this.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ali Abbas
Sent: Saturday, November 02, 2013 2:33 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Formula for calculate max number for
HAPPY DIWALI TO ALL FRIENDS..
From: excelvbacli...@googlegroups.com
[mailto:excelvbacli...@googlegroups.com] On Behalf Of Dharmendra Upadhyay
Sent: Friday, November 01, 2013 11:06 AM
To: excelvbacli...@googlegroups.com
Subject: Re: [XL-VBA Clinic] Happy Diwali.
Same to u your family
On
...@googlegroups.com [mailto:
excelvbacli...@googlegroups.com] *On Behalf Of *Ravinder
*Sent:* Friday, November 01, 2013 12:25 PM
*To:* excelvbacli...@googlegroups.com
*Cc:* excel-macros@googlegroups.com; Soum
*Subject:* RE: [XL-VBA Clinic] Happy Diwali.
** **
HAPPY DIWALI TO ALL FRIENDS
What information you want to get
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bill Q
Sent: Saturday, November 02, 2013 3:12 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Web Query Issues
Hi,
Not sure if this is the proper
PFA OR
=IFERROR(VLOOKUP(A2,CHOOSE({1,2},Contacts!$B$2:$B$13,Contacts!$A$2:$A$13),2,
0),UNKNOWN NUMBER)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of M.Rafique MRU
Sent: Sunday, October 27, 2013 9:57 PM
To: excel-macros
Subject: $$Excel-Macros$$
Try this one.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sagar Kasangottuwar
Sent: Monday, October 28, 2013 1:06 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro for consolidate worksheets from various
workbook to specific
various
workbook to specific workbook
Dear Ravindra,
Run time error 9 is showing after running macro. Kindly send me the macro
for copy sheets from various workbooks to single workbook.
Thanks ,
Sagar
On Mon, Oct 28, 2013 at 2:26 PM, Ravinder ravinderexcelgr...@gmail.com
wrote
PFA OR BELOW CODE
Sub putspace()
Dim rng As Range
Set rng = Application.InputBox(Please Select Range, Type:=8)
For Each T In rng
k = T
For i = 1 To Len(T)
j = Mid(T, i, 1)
If j = UCase(j) Then
k = WorksheetFunction.Substitute(k, j,j)
End If
T.Offset(0, 1) = WorksheetFunction.Trim(k)
PFA OR BELOW CODE
Sub putspace()
Dim rng As Range
Set rng = Application.InputBox(Please Select Range, Type:=8)
For Each T In rng
k = T
For i = 1 To Len(T)
j = Mid(T, i, 1)
If j = UCase(j) Then
k = WorksheetFunction.Substitute(k, j,j)
End If
T.Offset(0, 1) =
PFA OR BELOW CODE
Sub putspace()
Dim rng As Range
Set rng = Application.InputBox(Please Select Range, Type:=8)
For Each T In rng
k = T
For i = 1 To Len(T)
j = Mid(T, i, 1)
If j = UCase(j) Then
k = WorksheetFunction.Substitute(k, j,j)
End If
T.Offset(0, 1) =
Pls give some example file so
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rupesh Patil
Sent: Tuesday, October 29, 2013 10:43 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Validation Micro
Hi exports
I have sheet with some
PFA , If data in same format in all PFD so u can use this also.
You have to put acrobat reader exe path in coding.
MyPath = C:\Program Files\Adobe\Reader 11.0\Reader\AcroRd32.exe
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jocky Beta
Sent:
Pfa, if u like to use this...
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Wednesday, October 16, 2013 8:38 PM
To: excel-macros
Subject: Re: $$Excel-Macros$$ Data validation - Need help to prevent
Duplicate Entry
try this
Pls use this if you like this. (sorry missed attachment in last mail)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Wednesday, October 16, 2013 8:38 PM
To: excel-macros
Subject: Re: $$Excel-Macros$$ Data validation - Need help to
=INDIRECT(E$2!BTROW()+1)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pravin Gunjal
Sent: Friday, October 18, 2013 11:00 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to take values from other sheets with single
formula or VBA
PFA. IF u r looking for this.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Avinash
Sent: Thursday, October 17, 2013 2:07 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ week selection by criteria
hi all,
i want criteria based
Give some data...in which you want to work even dummy data.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of alisha malhotra
Sent: Tuesday, October 15, 2013 11:21 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help needed in creating a
Give some example..with xlsx file.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of garfin.in...@gmail.com
Sent: Monday, October 14, 2013 11:09 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Two spreadsheets , compare and produce a
E2=1-((1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2)
E4=1-((1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: Saturday, October 12, 2013 2:23 AM
To: excel-macros@googlegroups.com
Subject:
U can use this coding also in single line
Sub Rectangle1_Click()
Application.SendKeys (%mfvlookup%g~)
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dr
Sent: Thursday, October 10, 2013 5:29 PM
To: excel-macros@googlegroups.com
Subject:
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Thursday, October 10, 2013 5:45 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$ Display Vlookup dialog box with vba code
pfa
Use Cells(4, iPasteCol).address)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jewel Sharma
Sent: Tuesday, October 08, 2013 1:08 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Writing a string to a particular cell
Hi,
This should
I think u did not mentioned BITUMEN' in second sheet
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kannan Excel
Sent: Tuesday, October 08, 2013 1:41 PM
To: Google
Subject: $$Excel-Macros$$ INDEX MATCH DOUBT
HI,
PLS FIND THE ATTACHED FILE AND DO
, anybody help me
On Tue, Oct 8, 2013 at 2:25 PM, Ravinder ravinderexcelgr...@gmail.com
wrote:
I think u did not mentioned BITUMEN' in second sheet
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kannan Excel
Sent: Tuesday, October 08, 2013 1:41 PM
'!$A$2:$AQ$65000,MATCH($F$4,'MASTER
DATA'!$D$2:$D$65000,0),MATCH($B18$C$17,'MASTER DATA'!$A$1:$AQ$1'MASTER
DATA'!$A$2:$AQ$2,0)+COLUMN()-3)
On Tue, Oct 8, 2013 at 2:53 PM, Ravinder ravinderexcelgr...@gmail.com
wrote:
I think this one help u
From: excel-macros@googlegroups.com
:-)
THANK U BOSS, THANKS A LOT :-) ITS WORKING. :-)
On Tue, Oct 8, 2013 at 3:21 PM, Ravinder ravinderexcelgr...@gmail.com
wrote:
There may be different total number of rows in ur file
Try this
=INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER
DATA'!$D$2:$D$65000,0),MATCH($B18
U want this in which event like when u change value of sheet or do some
calculation or open file or activate sheet or any specific time ?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bill Q
Sent: Monday, October 07, 2013 2:05 AM
To:
a dynamic spreadsheet that monitors different stock prices that
is refreshed ever x amount of minutes.
On 07-10-2013 16:23, Ravinder wrote:
U want this in which event like when u change value of sheet or do some
calculation or open file or activate sheet or any specific time ?
From: excel-macros
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bill Q
Sent: Monday, October 07, 2013 2:05 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Email Trigger ?
Hi,
I am using Excel 2007 and have Gmail as my primary email account.
=IF(TODAY()$F$3,,IF(ISERROR(IF(MOD(D6,G6)=0,(D6/G6)*H6,ROUNDDOWN(D6/G6,0)
*H6)),,(IF(MOD(D6,G6)=0,(D6/G6)*H6,ROUNDDOWN(D6/G6,0)*H6
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Grkrishna Naidu
Sent: Monday, October 07, 2013 1:32 PM
To:
Query is not clear..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: Friday, October 04, 2013 7:05 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Complicated Formula (automatic add back)
Dear Experts
Pls solution my
recipient you are hereby notified
that any disclosure, copying, distribution or taking any action in reliance
on the contents of this information is strictly prohibited and may be
unlawful.
On Thu, Oct 3, 2013 at 12:07 PM, Ravinder ravinderexcelgr...@gmail.com
wrote:
Try this udf or pfa
=MIN(IF($B$2:$B$10=C2,$A$2:$A$10))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Tuesday, October 01, 2013 7:58 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Min based on condtions
Hello,
am trying to get
For Each cell In Selection
With cell.Characters(Start:=3, Length:=1).Font
.Color = vbRed
End With
Next
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Sunday, September 29, 2013 10:00 PM
To: excel-macros@googlegroups.com
=TODAY()+B2-A2
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Waseem Saifi
Sent: Monday, September 30, 2013 3:29 PM
To: excel-macros
Subject: $$Excel-Macros$$ Difference between time
Dear Experts,
I want to know total working time basis on in time
Hi,
Please suggest a formula as per the below mention query.
Weight Weight Weight PINCODE 0.5 1 1.5 744101 20 30 40 744102 10 15
20 Condition 1: Pincode wise Condition 2: Weight
Thanks in advance.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Hi Ashish,
Please find the attached file
On Mon, Sep 30, 2013 at 7:01 PM, ashish koul koul.ash...@gmail.com wrote:
can u share the excel file
On Mon, Sep 30, 2013 at 7:00 PM, Ravinder Kumar
ravinderbhardwa...@gmail.com wrote:
Hi,
Please suggest a formula as per the below mention
do u want to calculate
On Mon, Sep 30, 2013 at 7:03 PM, Ravinder Kumar
ravinderbhardwa...@gmail.com wrote:
Hi Ashish,
Please find the attached file
On Mon, Sep 30, 2013 at 7:01 PM, ashish koul koul.ash...@gmail.comwrote:
can u share the excel file
On Mon, Sep 30, 2013 at 7:00 PM
Website...
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Menaka Balakrishnamoorthy
Sent: Saturday, September 28, 2013 11:34 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to take the data from the webpage table and
paste it in the
But where u want to paste those formula means which range all sheets have
the same format..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mukesh Kumar
Sent: Thursday, September 26, 2013 3:10 PM
To: excel-macros@googlegroups.com
Subject:
Give us more information..for this.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sandes Bagwe
Sent: Tuesday, September 24, 2013 8:56 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ I need help on one Macro creation
Hello All,
I
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sridher sharma
Sent: Wednesday, September 25, 2013 3:58 PM
To: excel-macros
Subject: $$Excel-Macros$$ for due date
i m taken a loan from bank witch have due date 16 day after 1st date (
29/04/2013
=SUMPRODUCT(1/COUNTIF(A2:A595,A2:A595))
Actually this formula first count the all values (a2:a595)in full range
(a2:a595) then divide 1 by count of all values and add those with help of
sumprduct
Just like simple eg:- if count of any value is 4 so countif formula will
calculate {4;4;4;4}
experts help ***URGENT***
Hi Experts / Ravinder / Anil,
I need a small update on that file, which you guys had updated.
I need to collect data from almost 500 + files, and the macro is doing it's
job pretty well. :)
But facing a new issue, suppose I am collecting this data from
I don’t know more about this. U can use like below;
=SQRT((x2 – x1)^2 + (y2 – y1)^2 + (z2 – z1)^2)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Debasish Sahu
Sent: Monday, September 23, 2013 6:36 PM
To: excel-macros@googlegroups.com
Subject:
Not able to access website and not getting how its working.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Menaka Balakrishnamoorthy
Sent: Tuesday, September 24, 2013 2:42 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to paste all
Try this one..for getting number and character and u can use UDF given by
Ravi for get character
From: Ravinder [mailto:ravinderexcelgr...@gmail.com]
Sent: Tuesday, September 24, 2013 10:02 AM
To: 'excel-macros@googlegroups.com'
Cc: Soum (quote.ex...@gmail.com)
Subject: RE: $$Excel-Macros
=SUM(IF(FREQUENCY(MATCH(A2:A595,A2:A595,0),MATCH(A2:A595,A2:A595,0)),1))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Kumar
Sent: Monday, September 23, 2013 11:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Total Count of
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Monday, September 23, 2013 9:47 PM
To: excel-macros
Subject: Re: $$Excel-Macros$$ How to split Alphabetic Numeric data in
different cells
Image is not there, please send again with example excel file.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Waseem Saifi
Sent: Friday, September 20, 2013 2:57 PM
To: excel-macros
Subject: $$Excel-Macros$$ Auto Filter too short
In My Excel, Auto
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
PFA:-
=INDEX($H$1:$H$29, SMALL(IF(($P$4=$F$4:$F$29)*10,ROW($F$4:$F$29)),3)) FOR
3RD
=INDEX($H$1:$H$29, SMALL(IF(($P$4=$F$4:$F$29)*10,ROW($F$4:$F$29)),3)) FOR
4TH
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Muralidhar E
Sent: Saturday,
am trying to get count of unique records based on multi
conditions where I know what is Condition1 but I will be not knowing what
would be condition2.
Thanks,
Chandra
On Wed, Sep 18, 2013 at 12:30 PM, Ravinder ravinderexcelgr...@gmail.com
wrote:
=SUM(IF(FREQUENCY(IFERROR(--SUBSTITUTE((C2
Try this code.
Sub unprotecsheet()
Dim wb As Workbook
Dim sh As Worksheet
Set wb = ThisWorkbook
For Each sh In wb.Sheets
sh.Unprotect AAABAABABBAR
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhakar S H
Sent:
=SUM(IF(FREQUENCY(IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,),
),IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,),)),1))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Tuesday, September 17, 2013 6:00 PM
To:
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rejeeb Abdulrahiman
Sent: Tuesday, September 17, 2013 10:06 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Check Box In Excel
Hi Friends,
In Excel 2010, I would like to create a
PLS PROVIDE LINK OF THAT WEBSITE.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Murali prasad
Sent: Tuesday, September 17, 2013 12:29 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Stock prices data fetching through VBA
im trying to
Pls provide example file for more clarification.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rashid memon
Sent: Wednesday, September 11, 2013 2:19 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help Required : How i import Data in
Use below formula or attached file.may be u r looking for this..
=IF(A2=,,MONTH(A2)000SUM((MONTH($A$2:A2)=MONTH(A2))*1))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rashid memon
Sent: Wednesday, September 11, 2013 2:19 PM
To:
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Its working fine just correct the position of then of if
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu Pinky
Sent: Wednesday, September 11, 2013 10:52 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ am getting compile error
Hi
Hi Ashish,
Please confirm that the all data in a single sheet or in different
different sheets.
On Sat, Sep 7, 2013 at 11:13 AM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Seniors,
I want total count of Sold Items according to the state or months. I'hve
tried this through Counta
PFA,and try same in your file.
From: Excel_Lover idforex...@gmail.com
To: excel-macros@googlegroups.com
Sent: Sunday, September 1, 2013 8:15 PM
Subject: $$Excel-Macros$$ Keep Excel in Full Screen
Dear All,
I am using the below code in the Workbook_Open
pls provide the website and some dummy data with excel file.
From: ExcelSteve excel...@gmail.com
To: excel-macros@googlegroups.com
Sent: Friday, August 30, 2013 7:18 PM
Subject: $$Excel-Macros$$ Data from an excel sheet to a online web from
I have got some
pls provide the url of sharepoint website and excel sheet where you want data
From: Mithun Dhar dhar.mit...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, August 28, 2013 6:59 PM
Subject: $$Excel-Macros$$ VBA getting data from web site
I am
this is the default folder for saving addins if you want to save in different
folder select and save..where youwant to save
From: Divaker Pandey divake...@gmail.com
To: excel-macros@googlegroups.com; ashish koul koul.ash...@gmail.com; NOORAIN
ANSARI
pls advise where you want answer and what exactly.
From: Zibraan lucky60...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, August 28, 2013 11:41 AM
Subject: Fwd: $$Excel-Macros$$ Formula to highlight planned leave by
Conditional formating
Hi
101 - 200 of 248 matches
Mail list logo