jill

What is the easiest way to count cells with the same value, across columns? <tbody> A B C D E F G Jack Jill John Jane 4 Jack Jack John John 2 Jill Jill Jill 1 John Jack Jack Jane 3 </tbody> The first 4 columns have names as above, and column F has the...

Hi Team, I have a below data and we would want to know how many time word P has repeated continuously for each name. I have give the result which I require for Jack it should be 4 (Its repeated 4 times continuously) and for Jill it should be 2 (Its repeated 2 times continuously) and for James...

I have a data table of dates, first names, surnames and salary. I need to be able to lookup the salary on or before a given date. I need to do this multiple times so do not want to use the Control Shift Enter array construct. Any suggestions for a single line formula that can deal with the data...

Hi - I'm trying to put together a Booking Calendar but have come across a problem in that every Friday is a cross over day and ideally I need both names appearing in one cell. I am using the following formula to transfer the details from the "Bookings" sheet to the calendar. -...

Hi, I searched the forum but wasn't able to find an answer to my question: If I have a table (formatted as a table) with the following data: <tbody> ID Boy Girl Human Adult Jack 1 1 Jill 1 1 1 Boaz 1 1 1 </tbody> How can I generate the following table: <tbody> Boy Girl...

I AM working on a large geneoly project. I need to extract the names from a string and reposittion them if married Example: Jill [Jack Jackson] needs to be redone to say Jackson (Jack and Jill). The names always appear in that layout.