• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Selecting a Record That Appears Multiple Times in a List

Q1: How can I filter a record that appears multiple times within a list?
A1: Select the column range with the multiple records you want to filter. Then choose Data, Filter, Advanced Filter. In the Advanced Filter dialog box, check Unique Records Only. This will filter the list with the unique records that appear in the list.

Pasting Conditional Formats over Multiple Rows

Q1: When I create a conditional format in a row that equals a cell in that same row, how do I copy the conditional format down, equaling the corresponding cell in the same row pasted?
A1: From the Conditional Formatting dialog box, select Cell Value Is, equal to, and then the cell in the corresponding row. Remove the dollar sign ($) in front of the row number to make it relative instead of absolute. Now the format will copy down, equaling a cell in the corresponding row.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint