Search:

Type: Posts; User: itr674; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Re: PLACE TEXT RIGHT: place a character to the right in same place

    Thank you!
  2. PLACE TEXT RIGHT: place a character to the right in same place

    I am trying to put asingle text character al the way right when using "courier new" itlines up in he same place.

    The setup is:
    Name cell: Last, First
    Group cell: can be character two, three,...
  3. Re: ADD SPACES via FORMULA: baced on a number in adjacent cell

    Thank you!
  4. ADD SPACES via FORMULA: baced on a number in adjacent cell

    I need to add a certain number of spaces based on a number in an adjacent cell.

    Am concatenating several cells into one, and using Courier New font to line things up, but need to add a number of...
  5. IFERROR vs ISERROR: what would ISRROE solution be?

    Using Excel 2010

    I have numerous sheets with names in column E, with names on some sheets as Last, First, and other sheets as Last First Initial.

    Worked all day on trying to get the below...
  6. Replies
    27
    Views
    1,240

    Re: Spliting Middle and Last Names Issue

    Tagged for future reference...
  7. Replies
    3
    Views
    181

    Re: RETURN NAME: name is between -- and --

    Eric W--thank you!

    That worked perfectly although it showed me I may have to rearrange some file names because some files had another item between the persons name and the form name, but this...
  8. Replies
    3
    Views
    181

    RETURN NAME: name is between -- and --

    We have some file naming conventions where the persons LAST NAME and FIRST INITIAL is enclosed by "--", and then there is the form name then a period and the file application.

    S:\### xx\xxx\###...
  9. Re: SUBSTITUTE and CHAR(10): if cell to right is blank don't want the CHAR(10)...

    Gerald Higgins, thank you . As I was searching for another solution today, I saw that I never thanked you.
  10. CONCATENATION+SUBSTITUTE+CHAR(10): keep data in 4 different cells lined up data in 4 other cells

    First, I don't have capability to put an Excel sample table from this computer.

    I have data in range C8:J8.

    Number codes are in range C8:F8
    Dates are in range G8:J8.

    in cell A8 I capture...
  11. Replies
    3
    Views
    319

    Re: ISNUMER and MATCH: on two columns

    thank you, I think this will work.
  12. Replies
    3
    Views
    319

    ISNUMER and MATCH: on two columns

    is it possible to use ISNUMBER and MATCH on two adjacent columns.

    I want to use ISNUMBER and MATCH to return true i the formula finds A,B,C,D,,F,G,H,I, or J in either of the ranges.

    Range A1:A5...
  13. Replies
    0
    Views
    140

    CHART: dates on Y-axis and time on X-axis

    I am trying to figure out how to build a schedule chart with the dates on the vertical axis and times on the horizontal axis, and then use error bars for horizontal duration...

    The dates ae...
  14. Re: VBA CALCULATE ON SHEET CHANGE: trying to get book to calculate on sheet change

    now I need code that lists all sheets that have code on them...so I can delete the code off those sheets...
  15. Re: VBA CALCULATE ON SHEET CHANGE: trying to get book to calculate on sheet change

    Johnny C--thanks.

    1st I made sure I saved three workbooks with Autocalculate on, and put the Option 1 code in all three. Then opened them and selected a sheet but it did not calculate.
    2nd, I...
  16. VBA CALCULATE ON SHEET CHANGE: trying to get book to calculate on sheet change

    When I change to any sheet I would like the entire workbook to recalculate.
    I have a table that has sizes on it and then that table populates about 100 forms but when I change sheets i have to...
  17. Re: DATA VALIDATION: dropdown "x" and no more that one "X" in the range

    Just figured out I could use a "helper" cell with =if(COUNTIF($C$4:$G$4,"X")>=1,"","X") and that way when an X was selected from the Allow List "helper" cell, it would be blank in any other cell in...
  18. Re: DATA VALIDATION: dropdown "x" and no more that one "X" in the range

    I had already used that in Allow Custom, but I was wanting to be able to use the Allow List and Allow Custom together...
  19. DATA VALIDATION: dropdown "x" and no more that one "X" in the range

    If I have a range, C4:G4, where I want to place an "X" to indicate a size, but there can be no more that one "X" in that range, is there a way to do that with Data Validation, or will it have to be...
  20. Re: MULTIPLY TEXT by 1: vba for multiplying text cells by 1 but do not return #VALUE!

    The problem is some cells have N/A and then some cells are empty, well except for "return" character and spaces...I'm am still working it between other things...all this multi tasking is crazy...
  21. Re: MULTIPLY TEXT by 1: vba for multiplying text cells by 1 but do not return #VALUE!

    That code turns all cells to dates, so that seems not to work...
  22. MULTIPLY TEXT by 1: vba for multiplying text cells by 1 but do not return #VALUE!

    Using this code to get rid of extra character but then need to multiply by 1 to calculate dates correctly...I'm still actively working it...

    Public Sub Remove()
    Dim oCell As Range...
  23. Replies
    14
    Views
    541

    Re: Return matches into one cell

    Aladin, thank you, that pretty nice. But, what if the table was on one sheet with the names and training items but on another sheet was just the names and the combined column, would there be a way...
  24. Replies
    14
    Views
    541

    Re: Return matches into one cell

    textjoin(CHAR(10),1,IF($B2:$F2=1,$B$1:$F$1,"")

    Just realized that this UDF is using another sheet to get the data and if I short the other sheet or add/delete rows it throws everything off, so...
  25. Replies
    14
    Views
    541

    Re: Return matches into one cell

    Mike Szczesny, that really did not work because the Trn1, Trn2, Trn 3 are heading and the 1's represent person not trained, but have a bigger issue I just realized...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4