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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: flashbbeb
  • Content: Threads
  • Order by date
  1. flashbbeb

    change picture brightness from copy/pasted image

    Hi all, The premise here is that the user clicks a button in the ribbon, and the image is copied from the hidden location and pasted where desired in a table. But I want to make sure the image cannot be seen from where it is being copied. What I came up with was - hiding the images by changing...
  2. flashbbeb

    calculating an interval btw 2 dates

    Hello, I am very new to Approach, and have been asked to create a calculated field that shows the interval in years, months, and days between two dates. So the calc'd field would display "x years, y months, z days". I don't really know where to start...could anyone help? Thanks! EB
  3. flashbbeb

    add csv or xml data source

    Hi all, I'm very new to Cognos, and in training only covered ODBC connections. I have a flat file I need to use as a data source that comes to me as a pipe-delimited text file, which I usually convert (text to cols) to XLS to work with in Excel. The data itself is just a table with the first...
  4. flashbbeb

    lookup to replace partial strings

    Hi all, On one worksheet (Sheet1), I've got a column of strings (location names at my company) that are relatively unique. Unfortunately most of the strings max out at a length of 22 characters. So I've got a sad list of unfinished names. I have another worksheet (Sheet2) with a column of a...
  5. flashbbeb

    deleting specific XLS columns by macro

    Hi all, Novice coder here! I'm trying to create a macro that deletes specific columns - just by which one, not even by criteria like a cell value. I'd like to be able to do this with an array where I specify the columns, but I don't know how to loop through each slot in the array to delete the...
  6. flashbbeb

    Excel - get a cell value in a row with the max

    Could anyone please help with a formula that would present the value of a cell in column A, whose corresponding column B has the highest value? An example table, where the value the formula presents is Ryan (the max in column B being 128). A B Bruce 45 Jim 23 Ryan...
  7. flashbbeb

    Peoplesoft LMS experiences

    Is anyone using Peoplesoft's Enterprise Learning management? Would anyone be willing to share their experiences with it; i.e. cost, ease of use, ease of customization, end user satisfaction, ease of use for e-Learning developers and trainers... I'd really appreciate it! Thanks, EB
  8. flashbbeb

    getting an aggregate sum based on another column

    Hello, I'm working on a summary report with calculations of a specific count based on data on another sheet (called "Q108") in the same file. My summary report (called "Summary") must count the number of courses from the other sheet, listed as either ILT or e-learning. An example of the data...
  9. flashbbeb

    sumproduct

    Hi all, I'm a fan of SUMPRODUCT, but seem to run into issues at every turn. I'm trying to get a count of rows based on two criteria - the name of a course (column A), and the department (column M) that are on another sheet (qdata) in the same file. I am trying to use the formula on a summary...
  10. flashbbeb

    dynamic row numbers within a formula

    I'm using the SUMPRODUCT formula to calculate the number of times two different conditions are met: that in a column the value equals whatever is in a specific cell. What I would like to be able to do is refer to one of cells by a row number, so it dynamically adds the number without me having...
  11. flashbbeb

    checking previous cells in a column for same value

    Hi all, I'm trying to figure out if this idea is even possible... If the value of this cell is "dupSSN1" and "dupSSN1" exists in a previous cell in this column, then concatenate an "ins" to "dupSSN" in this cell. Example: dupSSN1 dupSSN1ins dupSSN2 dupSSN2ins ...where the formula has checked...
  12. flashbbeb

    formula to compare multiple columns

    Hi all, I'm trying to compare two different sets of data on the same sheet (as below), and want to check for uniqueness by a 3 column key. I'm not comparing cell-to-cell, but want to check the entirety of a column so that if a true duplicate appears anywhere between the two sets, a "match"...
  13. flashbbeb

    count based on multiple criteria

    Hi all, I'm familiar with SUMPRODUCT, and have used it to count the number of rows meeting multiple criteria. In previous circumstances, I've had concrete cell values to point to, either a specific string or a cell reference. In my current case, I'm doing something that's not as straight...
  14. flashbbeb

    count if cell values NOT in column

    Hi all, I'm trying to figure out how to get a count of cells in a column (all are strings) that do NOT include the values in a specific range. The range is specified in a separate column to the left. This is a list of about 50000 names of courses (exact repeats included), 17 of which (the...
  15. flashbbeb

    Excel formula - find with multiple ORs

    Hi all, I'm trying to populate a column that shows whether someone is a supervisory employee. The formula should parse a parallel cell in the job title column for any of the following strings: "AVP","Manager","Mgr","Spvr","Supervisor","Supv","SVP","V P","Vice Pres","Vice President","VP" If...
  16. flashbbeb

    run a JS function from another HTML file

    Hi all, I have a page that includes a JS-based tabbed menu. From another page, I want to be able to 1) launch the menu'd page and 2) take the user right to a tab (that isn't the default). The launch the page part is HTML 101 href stuff, but how do I get the link to run "step 2" when the...
  17. flashbbeb

    need to set cell value at certain intervals

    Hi all, I'm not sure if a macro or a formula would work best for this, but every 17 rows, I need the cell in the A column to be set as "Part". Thanks, eb
  18. flashbbeb

    text search in only one column

    Hello, I am creating a very basic glossary that has a text search function, and only want the search to apply to the words being defined (not the definitions). Being a novice with JS, I did manage to find some code that would search the entire page (below). Whoever created it didn't credit...
  19. flashbbeb

    ASP dynamic text - txt into html

    Hi all, I'm trying to create a page that dynamically pulls in text for different divs from a text file. Right now, I'm working in straight HTML/CSS with an announcements page, but I want it to be dynamic for others without coding experience to easily be able to update via a text file. I've...
  20. flashbbeb

    highest score for multiple ids

    Hi all, I have a list of duplicate user ID numbers for people who completed a course multiple times. Their record includes a score for each attempt at the course. I need to extract the highest scores for each user ID. Not being someone who can program from scratch, could anyone assist with a...

Part and Inventory Search

Back
Top