Hello VBA
You solution was perfect. thanks for the help, am really grateful. 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) Use concise,
I would use conditional formatting.
select cell B2
Click Conditional formatting/new rule/Use a formula to determine which
cells to format/.
enter =b2<>B1
Set the format you want - I used a light green fill
Click OK, OK
Select B2
Copy
Select the rest of column B (or as much of column B as you want
I can see that you can't share file. Can't you even share sample of fake
data? This can help us a lot to understand your query.
On Wed, Feb 20, 2013 at 9:20 PM, solsbee wrote:
> I have a spreadsheet that the data is keyed in one cell, then multiple
> other cells are populated by the index and m
I have a spreadsheet that the data is keyed in one cell, then multiple
other cells are populated by the index and match formula being tied to that
entry. My problem is sometimes I need 5 rows populated and other times I
may need 6. Is there a way to have excel show an error if a cell does not
Dear Noorain,
Sorry for the late reply.
What is the use of *small function* and *row function* here? How could they
use together to get the desired results?
Thanks so much for explanation in advance!!
2012/2/7 NOORAIN ANSARI
> Dear Darwin,
>
> Actually, It was query of one of our group member
Dear Darwin,
Actually, It was query of one of our group member Mr. Pravesh kashyap, He
wanted to extract all vertical data in horizontal way as per
provided heading.
In this case.Heading is repeating again by again in column "A"
below function was used to extract column "B" data in ho
Dear Darwin,
Please try it without using helping coloun.
=INDEX($A$2:$A$14,MATCH(SMALL($B$2:$B$14,ROW(A1)),$B$2:$B$14,0))
See attached sheet..
On Tue, Feb 7, 2012 at 2:09 PM, Darwin Chan wrote:
> Hi group,
>
> Currently I m reviewing the use of Index and match. However, anyone can
> point out w
ear Darwin
Kindly find the attached file
On Tue, Feb 7, 2012 at 2:09 PM, Darwin Chan wrote:
> Hi group,
>
> Currently I m reviewing the use of Index and match. However, anyone can
> point out what is missing in my forumla?
>
> --
> Darwin Chan
> darwin.chankaw...@gmail.com
> kw42c...@yahoo.com.h
Hi group,
Currently I m reviewing the use of Index and match. However, anyone can
point out what is missing in my forumla?
--
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor t
