Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by corbinap

  1. corbinap

    Create a form for responses and send

    Hi all.. I need help understanding best way to create an outlook form with questions where the receiver will input answer and send back
  2. corbinap

    Find verbiage and transpose values between each row with the verbiage

    Thanks for the quick reply - I am just now getting a chance to work on. yes getting rain also.
  3. corbinap

    Find verbiage and transpose values between each row with the verbiage

    Here you go - thanks in advance. curious what doing wrong. https://files.engineering.com/getfile.aspx?folder=c28b7586-75f2-41ae-97b1-d6ed1c872b2f&file=example_8.xlsx
  4. corbinap

    Find verbiage and transpose values between each row with the verbiage

    Hi Skip, the version of Excel I am using has Unique function but the formula returns 0 (zero). I have tried what you used for the ID and Title and I tried a range E2:E20. Nothing works. I also get an error that says using "=" or "-" is for formula.... so close - I have the table formulas...
  5. corbinap

    Find verbiage and transpose values between each row with the verbiage

    Thank you - I did not know how well I explained but yes normalizing makes sense but never had to do in Excel - worked with Access alot in past. I will let you know - again thank you
  6. corbinap

    Find verbiage and transpose values between each row with the verbiage

    I am needing to get values between rows with same verbiage in title. Really need help as will have a lot of records to go through. Provided file. IT might help to move the Verbiage to another column ID Title the Values under Title Status Thanks in advance Sub Transpose_my_cells()...
  7. corbinap

    Do loop to find text and add verbiage if found in another column

    Thank you but I need an array and have reposted also as need more help. Thx
  8. corbinap

    Do loop to find text and add verbiage if found in another column

    Do loop to find text in row and add verbiage in column based on value. Hi and thanks in advance. I am looking for a way if a word is found in a row then a value under the row will be moved to a column example and see attached. If "Stock" is found in column B row and column C shows "Good" then...
  9. corbinap

    Conversion error for date

    Thanks for all of the suggestions.
  10. corbinap

    Conversion error for date

    I am getting an error: Conversion failed when converting the nvarchar value '10/2007' to data type int. using: a.[calyearmonth] = b.[calyearmonth] - 1 calyearmonth is a nvarchar and I need to get previous month in table b. Do I need to covert calyearmonth somehow?
  11. corbinap

    Month to 2 digits

    thanks...
  12. corbinap

    Month to 2 digits

    But, I also need to add the 4 digits year in the front: yyyymm Declare @LastMonth varchar(2) SET @LastMonth = right('00' + convert(varchar(2), Datepart(mm,getdate())-1), 2); select @LastMonth
  13. corbinap

    Comparing two columns in different tables

    I have seen some information on not having exist I just need to compare two columns PrevMonth from EmpHist table and Currentmonth from Emp table and see what fields in Currentmonth from Emp table do not match or is null compared to PrevMonth column in EmpHist table...
  14. corbinap

    Month to 2 digits

    Thanks
  15. corbinap

    Comparing two columns in different tables

    How do I compare to columns in two different tables. By using Not in or Not Like. Can someone give me an example with two tables....Thanks.
See more

Part and Inventory Search

Back
Top