Jul 23, 2012 #1 Bollywood Chemical Oct 15, 2008 2 0 0 US Primary Secondary F V P T F T L V H Y F V T T X V F I F T T T P V H V Z SC H V F V L V H Y F I Above excel data on "sheet1". On sheet 2 tryin to count say e.g. number of "FV"s. Any suggestion for formula. Thanks.
Primary Secondary F V P T F T L V H Y F V T T X V F I F T T T P V H V Z SC H V F V L V H Y F I Above excel data on "sheet1". On sheet 2 tryin to count say e.g. number of "FV"s. Any suggestion for formula. Thanks.
Jul 23, 2012 #2 FrancisL Computer Aug 29, 2001 337 0 0 GB Data Pivot Table Francis http://www.controldraw.co.ukhttp://www.s88control.blogspot.com Upvote 0 Downvote
Jul 23, 2012 #3 RobD7 Chemical Jun 18, 2012 10 0 0 US If you use VBA, you can just do a count for y=1 to 50 IF cells(1,y)=F AND cells(2,y)=V then x=x+1, display x Upvote 0 Downvote
If you use VBA, you can just do a count for y=1 to 50 IF cells(1,y)=F AND cells(2,y)=V then x=x+1, display x
Jul 23, 2012 #4 pmover Mechanical Sep 7, 2001 1,500 0 36 US if cell values are text in separate columns, then try placing this formula is adjacent column =if(and(a1="F",b1="V"),1,0) if cell values are in same column, the try =if(a1="F V",1,0) you can then sum or count the "ones". crude method, but works. good luck. -pmover Upvote 0 Downvote
if cell values are text in separate columns, then try placing this formula is adjacent column =if(and(a1="F",b1="V"),1,0) if cell values are in same column, the try =if(a1="F V",1,0) you can then sum or count the "ones". crude method, but works. good luck. -pmover
Jul 24, 2012 #5 Latexman Chemical Sep 24, 2003 6,924 1 38 US Bollywood - this question should have went in the Engineering Spreadsheets forum. Red Flag your post and ask management to move it. You may get some other advice/options over there. Good luck, Latexman Upvote 0 Downvote
Bollywood - this question should have went in the Engineering Spreadsheets forum. Red Flag your post and ask management to move it. You may get some other advice/options over there. Good luck, Latexman