Thread: [Solved] Is there a way to print based on a particular filter?
View Single Post
 
Old 03-16-2012, 01:57 AM
Jamal NUMAN Jamal NUMAN is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Question
Quote:
Originally Posted by gsrikanth View Post
use this select first column named list in b2 kept this formula =INDEX(List,MATCH(0,COUNTIF($b$1:b1,List),0)) with ctrl+shift+enter

thank you for the answer gsrikanth.

i tried what you have already advised but sounds not to work with me. I'm not sure if your time permits to stick the equation on my actual excel sheet (which is provided in my previous post) so that i can proceed.

all the best

Jamal
Reply With Quote