• Maudibe's Avatar
    2016-08-30, 05:57
    Maudibe replied to a thread Match Formula Problem in Spreadsheets
    Good point zeddy. Comparing text ('3022 and "3060") to numbers (3022 and 3060) has an affect on many formulas. Howard will in this spreadsheet,...
    7 replies | 101 view(s)
  • Maudibe's Avatar
    2016-08-29, 17:06
    Maudibe replied to a thread Match Formula Problem in Spreadsheets
    Your welcome, glad to help. If you want to stick with the match function, this will also work: =IFERROR(IF(MATCH(D2,$A$2:$A$17,0),"In...
    7 replies | 101 view(s)
  • Maudibe's Avatar
    2016-08-29, 05:51
    Maudibe replied to a thread Match Formula Problem in Spreadsheets
    Howard, In G2 then copy down: =IF(COUNTIF($A$2:$A$17,D2)=0,"not in Sales", "in Sales")
    7 replies | 101 view(s)
No More Results
About scubajay30

Basic Information

Date of Birth
May 14, 1977 (39)

Statistics


Total Posts
Total Posts
20
Posts Per Day
0.02
Total Thanks
Total Thanks
9
  • Thanked 0 Times in 0 Posts
General Information
Last Activity
2014-09-29 14:21
Join Date
2014-06-16
Referrals
0

1 Friend

  1. Maudibe Maudibe is offline

    Gold Lounger

    Maudibe
Showing Friends 1 to 1 of 1