Search results

Thanks! '=IF(ISBLANK(A2),"",CONCATENATE(A2&"|"&I2))' worked! Most appreciated Sir!

Hello again everyone! Ran into an odd issue, Don't know if it's because I'm using "|(shift+)" delimitation or what. =CONCATENATE(A2&"|"&I2) works for most of my needs, but I'm trying to hide the "|" character for areas that haven't populated yet. I haven't been able to get a good IF...

Hi Narayan, http://www.mediafire.com/download.php?816a2022qv2exn7 the above link contains a partial list. I was using a VLOOKUP function to pull the part numbers to a new worksheet. Then I was using the formula you provided earlier to try and make a list of unique part numbers. Could it be...

Thanks for your analysis Narayan, I appreciate it. I did run into an issue with the array formula you provided to uniquely identify part numbers. For some reason, I'm receiving duplicates, and I don't know why. Do you have any pointers or need any additional information? I can provide a...

Hi Narayan, Thanks again for all your help. I think I need to give a total overview to make sure I'm going about this the best, most efficient way. I value any input you may want to offer. Overview: I'm using 2 ODBC connections that both update as the workbook is open. Each ODBC data pull...

Luke, Will that refresh pivot charts as well?

Thanks Luke, I'll give it a shot!

Hello again everyone! I appreciate all the help on this site, I'm learning a lot! I had a question about the order in which data updates in an excel 2003 spreadsheet. I have a workbook that uses 2 ODBC queries to update on open (one for each tab.) I also have the pivot table set to update on...

You're correct, the qty / time conversion calculations on my original post were off. Convert still works to convert hours to minutes, but cell-name *60 may be better. I had been focusing so much on the formula syntax that I didn't convert the last two portions correctly. Thanks! I finally...

I don't know if CHOOSE is going to be a viable option as one field determines a calculation that is likely to return a result that exceeds 29. I will try to explain more about my data... Column B has a number that can be anywhere from 0 to 100.99, if not higher. Column C gives meaning to...

Thanks Narayan, I'm not familiar with the transpose function. Would you mind explaining to me how that formula works? I see that each column only has one value posted, is that the rolling average for the unique part list in Column D?'m sorry to ask so many questions, but I'd like to understand...

I corrected the formula with `=IF(E2="MIN/PC",(D2),IF(E2="HRS/PC",(CONVERT(D2,"hr","mn")),IF(E2="PCS/MIN",((D2)*60),IF(E2="PCS/HR",((D2)/60),""))))' Just need to correctly convert from unit/time to time/unit now. any ideas?

OPERATION.CLOSE_DATE is a date/time field, as is WORK_ORDER.CLOSE_DATE. I've actually removed the "is Null" filters from both queries too. As far as sorting by proper order goes, we have 20-30 machines running at any time, so there are duplicate CLOSE_DATE entries. Not all machines log hh:mm...

Hello again! I'm running into an issue with my Nested IF function, Is anyone out there able to take a fresh look at my formula? Thanks in advance! I am trying to calculate one column based on the values in another column. Here is the formula I have so far, but it's throwing an error message...

That's a little more complicated... One SQL statement pulls half the data, while the second SQL statement pulls the other half of the data. From there, I'm using VLOOKUP between the two worksheets to join the data. because of the way the database was created (long before I started with the...

I got the Array part sorted out and added to the spreadsheet. Now the unique values show in column d. Please let me know if I need to add/remove anything else for the next part. Thanks again! Test Data: http://www.mediafire.com/download.php?ml6dtq2u838lug3

Hi Narayan, Thanks for the response! 1. As the spreadsheet opens, the data updates. From that point, it is a static set of data that can be worked on. As the connection pulls in new data each time the spreadsheet is opened, there may be any number of new rows added to the original data set...

I'm running into an issue providing data to our operations guys. I have a list of part numbers, (some of which are duplicates) in column A. In column B, I have a list of target "run times" for each part. (in minutes per piece) In column C, I have a list of Actual Run times for those same...