doe

Hello, I currently have a table with a couple thousand pieces of data. What I am trying to do is create a formula of some type to know all the corresponding dates to a certain person based on their status. <colgroup><col><col><col></colgroup><tbody> Name Status Last Modified John Doe...

Most of customer list comes in as: Doe, John or Doe, John & Jane It easy to change those to: John Doe or John & Jane Doe by using: =TRIM(MID(A2&" "&A2,FIND(",",A2)+1,LEN(A2))) However, we also have customers entered as: Doe, John & Smith, Jane and we'd like to have it appear as...

Hello, I am a noob when it comes to what I am asking help for and I'm willing to learn. I am planning to make a database for the youth program I over see. This is just one part I am needing help with. I have about eleven events that the youth competes in over a two and a half day period...

Hi,<o:p></o:p> I have a problem to which I can't find answer anywhere. I have a long list of costs with employee names. The problem is that the names in the list are not consistently written. Sometimes the 1st name comes first, sometimes the 2nd. E.g. it can be John Doe or Doe John. I have...

I'm trying to manipulate a very large file into a new format so I can work with it in Visio. For context, it's a succession planning file, where each current incumbent has their own row, but with each successor they add a row. For example: <tbody> Current Incumbent Successor Jane Doe Bob...

Is there a free add-in or template for large-scale factorial design? I'd like to perform a half-factorial experimental design with 6 variables, with high, low and zero values, ideally. I know there are software packages out there that can do this, but I don't think I'd have the $ to purchase...