Thread: Find & Extract
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Meeru Meeru is offline
external usenet poster
 
Posts: 16
Default Find & Extract

hi,
I have data in Col A and i would like to get the data in Col B only if the
value in Col A is greater than 3 and less than 5 .


A B
1 2
2 3
3 4
4
5
6

I am looking for a formula. Any ideas on this please.
best regards,
Meeru