Dear All,
I want to calculate date wise grouping of month closing Like:-
i have data of student
Raw Data ID Student name Course Date of
Registration Closing Dates From To Month3001 Sanjay English
01-01-2014 01-01-2014 26-01-2014 Jan3002 Anil Hi
Dear All friends
I required Rank formula with easy way to sort data for huge data &
arange as ascending order.
Pls find attached sheet with more information
I would appreciate very much if someone can help me on this
Regards
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
http://thereferraljob.com/?refer=33938
pls conform the above link to conform your payment
thanks
--
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
Dear Muddan
Thanks alot.its perfect.
Can we extract data with heading name & as per my selection cell point
where I select cell then data extract from that cell.
Regards
Amar
On Wed, Apr 9, 2014 at 8:17 AM, Muddan Madhu wrote:
> Try this
>
> Option Explicit
> Sub GetDataFromWeb()
> Dim STR As S
Try this
Option Explicit
Sub GetDataFromWeb()
Dim STR As String
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
STR = "http://www.investing.com/indices/major-indices";
Dim I As Integer, X As Integer
IE.Visible = True
IE.Navigate STR
While (IE.Busy Or IE.ReadyState <> 4)
Hello,
Good day to all. I have created by mistake personal.xlsb in Excel 7. I did
this when I was trying to save a file and picked xlsb by mistake. The file
name was not even PERSONAL, but was "Ch2". It was intended to be macro
enabled.
All files are unhidden and I know the path where the file
Thanks Paul & Ashish
Regards,
Ganesh N
On Wed, Apr 9, 2014 at 12:14 AM, ashish koul wrote:
> Sub sample()
> Dim i As Long
> Dim rng As Range
> Dim strng As Long
> Dim endrng As Long
> Sheets("Sheet1").Range("a1:b" &
> Sheets("Sheet1").Range("a1").End(xlDown).Row).Sort
> key1:=Sheets("Sheet
pls share sample file
On Mon, Apr 7, 2014 at 2:42 PM, Ashish Bhalara wrote:
> Dear experts,
>
> I want merge cell containing text value and want comma(,) between all cell
> value in cocatenate function but my query is that when cell value is blank,
> the comma should not be display. Is it possib
Sub sample()
Dim i As Long
Dim rng As Range
Dim strng As Long
Dim endrng As Long
Sheets("Sheet1").Range("a1:b" &
Sheets("Sheet1").Range("a1").End(xlDown).Row).Sort
key1:=Sheets("Sheet1").Range("b:b"), order1:=xlDescending, Header:=xlYes
On Error Resume Next
i = Application.WorksheetFunction.Match(
Hi Matt,
Please try this add-in
http://www.microsoft.com/en-in/download/details.aspx?id=21649
I am not sure but one of the reason can be you have applied formats in non
data cells( which is not even required). Please download the addin and try
to run it see if it solves your problem
Regards
Ash
Hi Matt,
Please try this addin
On Tue, Apr 8, 2014 at 11:25 PM, Matt Watson wrote:
> I have a formula and macro rich workbook. It has about 21 worksheets that
> I work in. I mostly paste in from other excel sheets; on one sheet I
> extract data from HTML through Text-to-columns and a few filte
I have a formula and macro rich workbook. It has about 21 worksheets that I
work in. I mostly paste in from other excel sheets; on one sheet I extract
data from HTML through Text-to-columns and a few filters via a macro.
What I run into is that despite selecting all cells and deleting the
data(
I did it two different ways.
You IMPLIED that you wanted a macro (hence, the button)
So, I used a technique in which I loaded a Dictionary object with all empid's
for the date specified, then looked through the list of all empid's and checked
for those that did not exist in the Dictionary object.
Hi Team,
Any updates on the request ??
Thanks & Regards,
Ganesh
On Tue, Apr 8, 2014 at 1:15 PM, Ganesh N wrote:
> Hi Team,
>
> Need a help in find the missed emp id list.
>
> Sheet1 have the actual employee ids and date. In sheet2 have overall
> employee ids in that i need to find the employe
Dear Experts,
I want to below link attach in excel for data import (Data-Import
External Data-New web query).I will try it but not working.After
Import data in excel Then automatic refresh in excel.
http://www.investing.com/indices/major-indices
Regards
Amar
--
Are you =EXP(E:RT) or =NOT(EXP
Hi expert,
is there any solutions on it.
On Tue, Apr 8, 2014 at 12:33 PM, Rupesh Patil wrote:
> Hello Expert,
> How to parse .xsd file in VBA. Please help
>
> --
> Thanks and Regards, Rp.
>
> --
> 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) !
Hi expert,
is it possible?
On Tue, Apr 8, 2014 at 11:59 AM, Rupesh Patil wrote:
> Hi Expert,
>
> I need your fover. let me explain you context.
> First I need to call web service from excel,
> I have to pass username and password to this web service,
> after user is validate .xsd schema well
Hi Team,
Need a help in find the missed emp id list.
Sheet1 have the actual employee ids and date. In sheet2 have overall
employee ids in that i need to find the employee missed on particular date.
Please find the attachment for your reference.
Thanks & Regards,
Ganesh N
--
Are you =EXP(E:RT)
Hello Expert,
How to parse .xsd file in VBA. Please help
--
Thanks and Regards, Rp.
--
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
19 matches
Mail list logo
