Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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