Search results for query: *

Oops - sorry - forgot to mention I'm doing this in Word.

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

I'm trying to connect the file to Cognos Framework Manager - I've never used (and don't have access to) Transformer or similar software to create cubes.

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

Found the answer: In the Column B on Sheet2 I'd add =VLOOKUP("*"&A2&"*",Sheet2$A:$A,1,0) Same old vlookup, but with the wildcard.

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

Thanks Skip and PHV. For further clarification, I'm using this macro on a file I receive every day that's formatted the same way - same columns in the same order every time. So in my particular case, hard coding the column numbers into an array is fine with me. So in the end - PHV's array with...

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

Thanks (as usual!), Skip! :)

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

Lilliabeth - you're right. I'm really looking for a sum here. I've been doing a lot with SUMPRODUCT recently, it didn't occur to me to use SUMIF. Thanks! Combo - I considered a pivottable, but would prefer to use a formula in this particular case. Thanks!

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'll give the indirect a try. I'm referring to the name of a course in the B column (this is a long list), where 14 different department names are listed above across the top (starting with cell F2). The count is how many course completions from a specific department. What I'd like to be able...

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

that did it. thanks, skip.

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

PHV - Thanks for the suggestion. The problem with that is that I'm not comparing row to row due to the data I have. It would work well if that were the case, but I'm comparing a row of exact cells (so, yes A1&B1&C1) against 3 columns, searching for the same 3 values anywhere within the column.