fred

  1. W

    Next blank row moving down through a data set

    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...
  2. A

    Parse email address from long strong

    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...
  3. I

    Simple macro required to add 001 after a name please

    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...
  4. stovvy

    Looking up a value in data source, matching on another criteria and outputting a value from a third column

    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...
  5. P

    Merging Cell Information

    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...
  6. T

    Pivottable for Yes, No, N/A Responses - Why is it so convoluted?

    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...
  7. J

    Anyone can optimize these lookup / sumifs ?

    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...
  8. T

    Any chart our there that can handle non-time-aligned but related data?

    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...
  9. J

    this ones to complex for me

    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...
  10. S

    Aufilter by contents in another cell

    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'...
  11. T

    Function returning value with assigned binary value

    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>...
  12. T

    Obtaining value from most recent duplicate

    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...
  13. S

    SUMIF as DAX measure

    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...
  14. E

    Conditional Inclusion of Text in a Column

    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...
  15. G

    Issue with countifs formula

    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...
  16. G

    Index Match where names are not exact match.

    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&"*"...
  17. A

    SWITCH in DAX with RELATED TABLE

    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...
  18. D

    Lookup name, then date within dates

    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...
  19. S

    Help with Reformatting/Calculating spreadsheet

    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...
  20. M

    Count blanks based on criteria of a name.

    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 ??

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top