nancy

I am looking for some assistance with a formula. I need it to say if there is text in g11 through g15 I need it to calculate 192*(each field with a text entry) in cell H22. Example: (This would be 192*3 since three of the 5 cells have text so H22 would read 576) <tbody> James Nancy...

<tbody> AUS BOB BOB DREW HOU DREW BOB BOB DFW DREW NANCY DREW CRP BOB NANCY NANCY NAS NANCY DREW DREW </tbody> Hoping someone can help with this. I have a spreadsheet like this I need t be ale to pull the list of data in column A based on a give name...

I've seen formulas that can extract unique values from a row or column, like {=IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D2, $B$3:$B$15), 0)),"")} but I can't make this work for a range of cells, like this: <tbody> A B C D E F G H I J K L M N 1 Bob Alice David 2 Mark Alice...

I need an excel formula to do the following name conversion: Current format: Tom & Nancy Smith Desired format: Smith, Tom & Nancy I have seen other examples that work with only one first name and one last name, but none for a couples first names. Thanks in advance, bateswi