fred

I have a table of data which is broken up by a number of blank rows at irregular spacing. I need to find the row number of the next blank row after the last occurance of a string in col A---which can be somewhere in the middle of the data table. I've got the row number of the last occurence of...

Hello I have a long string of email addresses - in the hundreds that are all in one line. They are bracketed by <> and separated by ;. How do I parse them into their own cell? Example: Fred Johnson<fred.johnshon@bla.com>;Jaime Post<jpost@yahoo.com>'......... I want to turn into...

I would like a Macro to add 001 after a name. This will now be a one off press of a button then not used. Some info for you. Worksheet called POSTAGE Column B Range B8:B881 I now need to add "SPACE 001" no quotes to All the names which do not have 002 003 004 etc after them. My list at present...

I have the following query and cannot for the life of me get any kind of nested formula to work. What I require is it to look at cell A1 in Sheet 2 and in Sheet 1 look for that cell in Column A (which appears more than once), but then look at Column B for a zero and then take the value from...

Col Col A Col B <tbody> First name Last name Mrs Brown, Lisa Tom Smith Fred Jones Mr Delph, Clive Stuart Round </tbody> Any idea how I would merge the two columns in order that I can read this as Mrs Lisa Brown / Tom Smith / Fred Jones / Mr Clive...

I have a table where rows are individual submissions, and columns are questions within those submissions. Submissions contain information such as name, month & location, and questions are answered with either Yes, No or N/A. <tbody> A B C D E F G 1 Name Month...

Hi, i have the following: <tbody> Name Pass Rate Previous Score Accumulative Points Accumulative minus Reduction Result Value John 100.00% #DIV/0! 89 89 PASSED 89 Luke 0.00% 0 0 0 FAILED 44 George 100.00% 0 82 82 PASSED 82 Tim 100.00% 0 95 95 PASSED 95 Luke 0.00% 44 0 0 FAILED 63...

By "non-time-aligned" I mean... I am getting data for say 2 columns of similar categories but there may not be data for both categories for the same time. Very hard to explain. <tbody> Time John Fred 10 am 3 5 10:09 am 9 11 am 6 2 11:23 am 7 1 pm 5 1:56 pm 2...

Sheet 1 holds all the information. Sheet 2 is going to be a kind of chart that I want to be auto created. on Sheet 1, Column A is the names, Column B is the Column # on sheet 2, Column C is the starting row # on sheet 2, Column D is the amount of times I want the name to be repeated...

Hey all, Hopefully a quick one for you guys. I am looking to auto filter G6:G500 depending on the contents in G4. For example, if G4 contains 'Fred' all the G7:G500 cells containing 'Fred' are filtered and become visible. If G4 changed to 'Dave' all the cells in G7:G500 which contain 'Dave'...

I'm looking for a function that would return a value which has a binary characteristic assigned to it. More specifically, a function that would only return the values with 1 assigned to them (i.e. male employees) into the male employee list but disregard any female (i.e. 0) employees <tbody>...

Hi All, I have a vertical list from A1:G1 John Fred Alex John Tim Fred John There are also values in B1:G1 next to those names which are irrelevant. For the second "John" I need a formula to search the vertical list above it (from bottom to top), find the first "John", and obtain the value...

Hi can someone advise how to execute a calculation over a subset of rows only? In my case, I have a table that lists customers and their individual sales. I need a dynamic measure that loops over each customer, and adds their sales to give a total figure. Example - Customer, Sale, Total...

This is the kind of thing I am trying to do: 1. I will enter the names of people in column A of Sheet 1. 2. In column B of Sheet 1, I will implement a checklist with two options - Yes and No 3. I will select Yes for each person whose name I want to have appear in another column-based list that...

I have the following formula in a spreadsheet which works correctly, however we have a new team member and the count does not work for them, i presume it has something to do with " ' " in their surname. =COUNTIFS('Sharepoint history'!H:H,SUBSTITUTE('Instructions '!L3," ","*"),'Sharepoint...

Hello, I am struggling with the correct formula, I have various sources of data, which contain names in diffferent formats, for example fred Smith and Fred S Smith. I put together the following formula which i though would pick these names differences up within the "*"&'Instructions '!ls&"*"...

I'm in Power BI trying to add a calculated column. I've got two tables, and a join between them: 1:n. Table 1: <tbody> ID Description 1 Bing 2 Bang 3 Bong </tbody> Table 2: <tbody> ID Name 1 Joe 2 Fred </tbody> I can join them together like this: <tbody> ID...

I tried to search for this and was unable to find it. If someone knows of an existing thread, please link me to it as I don't wish to recreate the wheel. I am trying to create a formula that takes the name in table 1 and looks it up in table 2. If it finds that name, it should look up the...

HelloAll, I am new to the VBA world, but I have beenusing the different threads here to answer some of my more basic questions, buti have kind of a complicated one. Here goes... I have an Excel spreadsheet that contains usertransaction data for an inventory system that we use. Each row...

Hi all! I would like to count of the names "fred" column B but then i want to count all blanks in columns LMNOPQ that fred has left blank. These columns are both numbers and text. This what I have so far. COUNTIFS(A:A,"FRED",L:Q," "). Thanks in advance ??