ibm

Hi, I have a huge data which I need to search for Vendor with "delete" note, delete the whole row from the current worksheet and paste the whole row data into a new worksheet. Below is the sample data: Original - before the deletion - Sheet1 <colgroup><col width="129" style="width: 97pt...

Good afternoon, I need some assistance on finding a formula! Jumping straight to the point, here is my predicament: <tbody> Customer # Customer Name Master Price Level 0001 0002 0003 0004 0005 x apple 1 y ibm 2 z dell 3 </tbody> I am trying to look up a value under...

Thanks in advance for any advice. My issue is I am trying to find a way to first extract the last word in a string depending on what is in that last word. For example, the strings are option symbols as follows IBM US 05/18/18 P40 IBM US 05/18/18 C140 IBM US 05/18/18 C14.5 IBM US 05/18/18...

Hi, I would like to know if any one has connected IBM Cognos Tm1 through excel VBA and also wanted to know the library if you have used it. I am the new user of tm1 prior to that I worked on Smartview addin. Smartview addin had good future by using codes Hypcreateconnection and hypconnect you...

I am very new in SQL and the software IBM Cognos and I was tasked as an intern to create a report with a header ((months) 1, 2, 3) and under this header an actual value and a target value. What I am looking to do is to filter out the blanks in the cells actual and target values under a certain...