Dear De Premor & Ravinder Sir,
Thanks for your help and valuable support. Thanks a lot.
Thanks,
Ashish Kumar
On Saturday, September 7, 2013 11:32:20 AM UTC+5:30, De Premor wrote:
>
> The good thing is that your sheet name have a same name with what we are
> looking for also the name of month,
Hi Raj,
Please find the attachment.
Regards,
GN
On Sat, Sep 7, 2013 at 11:28 AM, Raj Kumar wrote:
> Hi Group,
>
> I need Pen Drives Count of the attached file. kindly help it.
>
> Regards
> Raj Bharti
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2
The good thing is that your sheet name have a same name with what we are
looking for also the name of month, so we can process it easily, try
this on B2
=COUNTA(OFFSET(INDIRECT($A2&"!$A1"
),2,MATCH(B$1,INDIRECT($A2&"!$1:$1"),0)-1,2^16))
On 07-09-2013 12:43, Ashish Kumar wrote:
Dear Seniors,
Dear Senior,
All data in single workbook in different sheets and i want to create a
summary in output sheet. Data pattern will be same according to the sheet
which i'hve attached for query reference.
Thanks,
Ashish
On Saturday, September 7, 2013 11:22:03 AM UTC+5:30, Excel Group wrote:
>
> Hi
Hi Group,
I need Pen Drives Count of the attached file. kindly help it.
Regards
Raj Bharti
--
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
Hello friends,
Let's say I have an Excel File with VBA and an a Form that is used to make
entries in sheet. Is there a way I can make a Google Doc of it keeping the
Form and all the VBA? I searched and found that Google docs do not support
VBA but Java Scripts. Can someone share a way forward?
On
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 wrote:
> Dear Seniors,
>
>
> I want total count of Sold Items according to the state or months. I'hve
> tried this through Counta formula but this is h
Dear Seniors,
I want total count of Sold Items according to the state or months. I'hve
tried this through Counta formula but this is huge volume of data, so
please suggest me the easy way.
Thanks,
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,D
>
> Hi,
>
I just realized that if i can search the values of table 2 in table 1 it
will work for me i am not concerned with status now .. for ex...i want to
search all the values( 121, 123, 124 ) present table 2 in table 1
...please let me know the formula
Regards,
Ashwani
--
Are you =EXP(E:R
Ravi,
Screen shot wouldn't do any good.
It's not one Excel File, it's a bunch of them (I quoted "3" on my post but
it's actually "8"
not that it matters).
This is an issue with Excel 15 vs earlier versions.
It's possible that it might be a "setting" in Excel 15 that's causing my
issue.
As I ju
Sam,
Tried those. Didn't work. But thanks.
Did I mention that I hate version 15 (and Windows 8 (this is running on Win
7 by the way)).
Already worked through the missing Calendar Control (DOH!! Why did they get
rid of that??).
Still having issues with the Application.FileSearch
"Mr. Bill" really
Dear John,
Would u share any screen shot or excel file with us.
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of John Wilson
Sent: Saturday, September 07, 2013 8:01 AM
To: excel-macros@googlegroups.com
Subject:
Thanks a Lot De Sir.
On Sat, Sep 7, 2013 at 9:59 AM, De Premor wrote:
> Try this !
>
> Sub HideYes()
> Dim Rng As Range
> For Each Rng In Range("A2:E2")
> If InStr(1, LCase(Rng), "yes") > 0 Then Rng.EntireColumn.Hidden =
> True
> Next
> End Sub
>
>
> On 07-09-2013 10:46,
HI,
You can try this..
Sub Hidecol()
Set Rng = Range("A2:E2")
For Each r In Rng
If UCase(r.Value) = "YES" Then
r.EntireColumn.Hidden = True
End If
Next
End Sub
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googl
Try this !
Sub HideYes()
Dim Rng As Range
For Each Rng In Range("A2:E2")
If InStr(1, LCase(Rng), "yes") > 0 Then Rng.EntireColumn.Hidden
= True
Next
End Sub
On 07-09-2013 10:46, Prafull Jadhav wrote:
Dear All,
Very Good Morning
I have one Query .
i am looking in Range (
Hi Guys,
For eg my web service looks like
http://example.com/stockquote/service";
xmlns:tns="http://example.com/stockquote/service";
xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/";
xmlns:defs="http://example.com/stockquote/definitions";
xmlns="http://s
Dear All,
Very Good Morning
I have one Query .
i am looking in Range ("A2:E2") . If cell contain "yes" word then don't
hide otherwise hide the column .
for example
if in A2 Cell word is "Yes , i am Fine" then "A" column must be hide
if D2 cell contain "Prafull ,Yes is is fine" then D column mus
Interesting. I've worked through 8 to 14, never got a chance to work on 15.
Did you try changing the modal property of the userform? Or a line in the
end saying UserForm.activate?
Sam Mathai Chacko
On Sep 7, 2013 8:01 AM, "John Wilson" wrote:
> I'm in the process of upgrading / rewriting a busin
I'm in the process of upgrading / rewriting a business application in Excel
that I started years ago.
It's shared on our network and people with Versions 8 through 15 are using
it (now you get an
idea of my headache).
One issue (actually quite a number but just this one for now) and it seems
to
El lunes, 2 de septiembre de 2013 02:09:32 UTC-5, prkhan56 escribió:
>
> Hello All,
>
>
>
> You can use =COUNT.IF($B$9:$G$66,$A70)
>
--
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.
hi pls. share example of formatting
Bsl.
2013/9/6 Anil Kumar
> Hi
>
> plz help me
>
> I have a set of data (about 3000 records) that are in the following format:
> Name: name1
> Address: address1
> City: city1
>
> Name: name2
> Address: address2
> City: city2
>
> I want the records to look lik
I am new to web service and my task is to fetch data from webservice by
passing the arguments and my webservice specified below using vba. With the
url i could get the xml of this content. But i dont know how to pass the
patameter to the webservice "getTerm" and get the output. Anyone can help
Hi,
Provide the example output.
** * Best Regards,
Ms Excel User
*
**
On Fri, Sep 6, 2013 at 9:07 PM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:
> Hi Kartik,
>
>
>
> Thanks for looking into this. The result is still not what I want. I have
> tried to explain it
Hi Kartik,
Thanks for looking into this. The result is still not what I want. I have
tried to explain it below
Table 1
Table 2
*ID*
*Status*
*ID*
*status*
121 =
active
121=
*Ok*
123=
active
123=
Ok
124=
active
124=
Ok
125=
active
126=
active
So if ID 121 =active (statu
Please find attachment, hope this is the result you are looking for. If i
understood wrongly please let me know in breif
Regards,
Kartik
On Fri, Sep 6, 2013 at 3:19 PM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:
> Thanks for reply guys , but the output I was looking was that if the
Hi,
Can someone please help me with this?
Regards,
Ashwani
On Fri, Sep 6, 2013 at 3:19 PM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:
> Thanks for reply guys , but the output I was looking was that if the lookup
> table has ID 121 with Status as “ Ok” but in original table ID 121
Hi
plz help me
I have a set of data (about 3000 records) that are in the following format:
Name: name1
Address: address1
City: city1
Name: name2
Address: address2
City: city2
I want the records to look like the following:
Name Address City
Name1 Address1 City1
Name2 Address2 City2
===
Thanks for reply guys , but the output I was looking was that if the lookup
table has ID 121 with Status as “ Ok” but in original table ID 121 status
is “active” so I should come to know of the mismatch
On Fri, Sep 6, 2013 at 1:01 PM, Kartik Dale wrote:
> Hi Ashwani,
>
> Please find attachment.
Hi Every One
can anyone help how to converted Number in words into Numeric Values
let me know is their any formula or macro for for this
Kindly refer the attached sample date
--
Thank You
Patil MG
91 99016 16995
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=
Hi Ashwani,
Please find attachment. Just drag the formula in F column if you need it.
Regards,
Kartik
On Fri, Sep 6, 2013 at 11:03 AM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:
> Hi,
>
> I have a query. I have two table named original and other.
>
> Now I want to look up for ID,s
Hi,
Thanks for the reply will check it out.
Regards,
Chandra
On Thu, Sep 5, 2013 at 3:46 PM, xlstime wrote:
> Hi,
>
> Just UN-check "Check compatibility when using saving this workbook"
>
> or save file in XLSX format
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Thu, Sep 5,
31 matches
Mail list logo
