J
John
HI, HELP REQUIRED WITH FORMULA FOR EXCEL PLEASE
Q:
EXCEL WORKBOOK WITH TWO SHEETS, ONE TITLED MON & THE OTHER STAT.
ON SHEET MON, I HAVE TWO COLUMNS (H, K) WITH A RANGE OF SAY 20 LINES EACH.
ON SHEET STAT, I HAVE TWO CELLS (B5, F5) ON A LINE.
I WANT ‘MON’ ‘H’ TO COMPARE WITH ‘STAT’ ‘B5’.
ON ‘H’ LINES THAT MATCH WITH ‘B5’, IF A NUMBER IS ENTERED IN THE
CORRESPONDING ‘MON’ ‘K’ LINE, ‘STAT’ ‘F5’ WILL COUNT IT.
EXAMPLE:
‘STAT’ B5 = MM
‘MON’ H8 & H12 = MM
‘MON’ K8 = 0800 & K12=’ANYTHING BUT A NUMBER’
RESULT ON ‘STAT’ F5 SHOULD BE ‘1’
THANKS!
JOHN
Q:
EXCEL WORKBOOK WITH TWO SHEETS, ONE TITLED MON & THE OTHER STAT.
ON SHEET MON, I HAVE TWO COLUMNS (H, K) WITH A RANGE OF SAY 20 LINES EACH.
ON SHEET STAT, I HAVE TWO CELLS (B5, F5) ON A LINE.
I WANT ‘MON’ ‘H’ TO COMPARE WITH ‘STAT’ ‘B5’.
ON ‘H’ LINES THAT MATCH WITH ‘B5’, IF A NUMBER IS ENTERED IN THE
CORRESPONDING ‘MON’ ‘K’ LINE, ‘STAT’ ‘F5’ WILL COUNT IT.
EXAMPLE:
‘STAT’ B5 = MM
‘MON’ H8 & H12 = MM
‘MON’ K8 = 0800 & K12=’ANYTHING BUT A NUMBER’
RESULT ON ‘STAT’ F5 SHOULD BE ‘1’
THANKS!
JOHN