Hi,
Try this..
Sub lookupconfirm()
Range(F3).Formula = =IFERROR(IF(VLOOKUP(E3,A3:A7,1,0)0,OK),Not
OK)
Range(F3).Copy
Range(F3:F Cells(Rows.Count, 5).End(xlUp).Row).Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
Warm Regards,
Ravi
Hi,
Thanks for the reply will check it out.
Regards,
Chandra
On Thu, Sep 5, 2013 at 3:46 PM, xlstime xlst...@gmail.com wrote:
Hi,
Just UN-check Check compatibility when using saving this workbook
or save file in XLSX format
.
Enjoy
Team XLS
On Thu, Sep
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 and
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
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 kartik.1...@gmail.com wrote:
Hi Ashwani,
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
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
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 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
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 below
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 pls. share example of formatting
Bsl.
2013/9/6 Anil Kumar kumarmaury...@yahoo.com
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
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 @
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
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 wilson9...@gmail.com wrote:
I'm in the process of upgrading /
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 must be hide
Hi Guys,
For eg my web service looks like
?xml version=1.0?
definitions name=StockQuote
targetNamespace=http://example.com/stockquote/service;
xmlns:tns=http://example.com/stockquote/service;
xmlns:soap=http://schemas.xmlsoap.org/wsdl/soap/;
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,
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
Thanks a Lot De Sir.
On Sat, Sep 7, 2013 at 9:59 AM, De Premor d...@premor.net 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,
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:
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
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 just
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:RT)
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
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?
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
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
28 matches
Mail list logo