Hi Ashish
=IF(EXACT(F7,VLOOKUP(F7,A5:B7,1,1))=TRUE,VLOOKUP(F7,A5:B7,1,1)," NO EXACT
MATCH")
Is the corrected formula.
Regards,
Andy
On Thu, Nov 12, 2009 at 11:44 AM, ashish koul wrote:
> hi sir
>
> can u please check whats wrong in the formual want to do case sensitive
> vkooup
>
> thanks
>
>
Thank you Hemant,
I'm just limiting the number of records the user is able to store. I'm
using template, before going further user has to input some codes to
proceed.
Thnks.
On Thu, Nov 12, 2009 at 12:08 AM, Hemant Hegde wrote:
> Hi :)
>
> Why do you want to do that with the poor user? (he wil
hi sir
can u please check whats wrong in the formual want to do case sensitive
vkooup
thanks
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://
Hi Ashish,
You can simply use the exact match option of vlookup to do this.
The following links from MS have the complete explaination:
XL: How to Perform a Case-Sensitive Lookup
http://support.microsoft.com/kb/214264
How to Use VLOOKUP or HLOOKUP to find an exact match
http://support.microsoft.
what are you developing, a standalone app? an Excel solution?
"imports data from Excel" to what ?
I would guess you are reading the cell which contain a FORMULA aka: fx
OR function that is not available to your "APPLICATION" (ex. a UDF
(User Defined Function). the solution would then be to read the
I can't really help you with part 1,but
**do you now about auto_size, take a look at it
**if you want resize the height of rows 10 to 26 just select them (by:
selcting and dragging down the row numbers, OR select you first and
Shift select the last row) and when you resize by dragging row border
th
Paul, did you answer anything about printing?
What exactly would your macro accomplish?
On Nov 10, 7:17 am, Paul Schreiner wrote:
> ASSUMING that column "A" ALWAYS has data,
> then you could use:
> '--
>
I forgot the ending
When are you going to decide where you want it to be copied ? (Yes, I
mean the whole list of places.)
On Nov 10, 3:44 am, Chris wrote:
> Hi,
> I would like to know if this is possible in excel 2007 and any
> pointers where to look.
>
> - I have a block of cells (like a sort of
1.you probably mean paste (not copy) X amount of times, bec. usually
any 1 copy(ctrl+C) can be pasted many times
2.if it is a table (in prior to 2007 versions "list") it is already an
object, either with a default name or the name you assigned it
3.if it is not a table, use named ranges to give the
.CurrentRegion.Select
is the equivalent to " ALT + * " ( * meaning "Shift 8")
On Nov 11, 1:40 pm, Paul Schreiner wrote:
> There are several "neat" ways to do this.
> But quite a bit depends on your specific situation.
>
> for instance,
>
> If the sheet contains ONLY the information you are intere
is this what you mean
"[known_first_cell].CurrentRegion.Select"
this would select the area containing all cells with data around your
known 1st cell
On Nov 11, 1:40 pm, Paul Schreiner wrote:
> There are several "neat" ways to do this.
> But quite a bit depends on your specific situation.
>
> for
how can i go for case sensitive Vlookup and as well as using case sensitive
in if condition
thanks
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
h
Hi Paul
I managed it without a constant inside type block but I wanted to dceclare
one because
I use many subs where I use (and plan to use) custom type variables to write
to and read from binary files (eg: save, open, import from old file, convert
file to higher version etc) and I dont want to r
I'm not sure of any other ways, but one piece of advice:
Determine what the "default" formatting is for the sheet.
Save the "default" once.
then, check the cells against the default.
Only save those that DIFFER from the default
(or perhaps only the features that are different)
that way, when you
There are several "neat" ways to do this.
But quite a bit depends on your specific situation.
for instance,
If the sheet contains ONLY the information you are interested in,
(as in: Rows 1-500 contain data and the rest of the worksheet is blank)
and column "C" ALWAYS has a value,
You can use:
Hi :)
Why do you want to do that with the poor user? (he will have to re-open it
and probably with macros turned off)
You can
Protect the sheet or
Set the scroll area by putting this code :
Sheets("name").scrollArea="A1:Z10"
If you anyway want to close the workbook, this can help
write
If no
Hi
Thank you Paul and RolfJ
The file I want to save in binary format already contains 4 ararys of
variable size (these are to store: the file version info, settings and user
preferences, main data, and other data)
The excel formatting I and values I am trying to save is just a part of the
above
In a macro, I would like to be able to select a group of contiguous
cells containing information, where I know the location of the first
cell but not the location of the last cell in the group. I also know
that the only cells in the column containing information are in the
group of cells to be sel
Dear Hemant,
Thanks a lot for showing interest in helping me
Actually, it is combination of "Txt", date & amc column
Thanks & Regards
Prasad Gadgil
Cell: 9819442088
On 11/8/09, Hemant Hegde wrote:
> Hi :)
>
> I saw your file. Its fine but what are
>
> 401114 and
>
> 40120
>
> in
>
> TXN4
19 matches
Mail list logo