2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Call Log help - conditionally formatting pairs of rows that refer to the same event, but from reciprocal ends.

Our take

If your team frequently handles calls for one another, it’s essential to log these interactions effectively, even when the details might be overlooked. To manage this, consider using conditional formatting to highlight pairs of rows that refer to the same event. By checking for matching date values and reciprocal caller information across your log, you can easily identify related calls. This approach not only simplifies tracking but also ensures that every call is acknowledged, enhancing your team's productivity and accountability.

Would love any tips for this - I am not super familiar with formulas, so please forgive any gaps in my explanation.

Context: Everyone on my team can answer the phones, so we frequently get calls intended for our colleagues.

I need to log the calls, but since we’re not very tech-savvy, I know there’s a possibility that people may forget to write anything down. So I came up with the forwarded to/from columns.

If one colleague on either end of the forwarded call forgets to log it, it’s not a problem. As long as at least one person logs the call, it’s counted as one call. All I need to do is easily notice if two rows can refer to the same call.

The logic would go something like this: if there are two rows with the same date value in A, where one row’s B and C matches the other row’s D and B, respectively, then highlight both rows.

Any help would be greatly appreciated. I’ll note that since our call volume is not super high, I am comfortable with just highlighting rows and not formulating a duplicate taking off 1 from the total call count - unless that’s actually easier, formula-wise, than making a conditional highlighting rule that helps me manually adjust the total.

Added image example.

submitted by /u/domsumsub
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#rows.com#financial modeling with spreadsheets#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#row zero#AI formula generation techniques#Excel compatibility#formula generator#Excel alternatives#call log#conditionally formatting#reciprocal ends#forwarded calls#logging calls#team communication#call volume#highlight rows#date value#conditional highlighting