Search results

Narayan - Yes I see the differences. I will let all this sink in today and play with it this weekend. Thanks for the help. jay

Narayan - Thank you!! As I read the code, I'm seeing "items in the same cell." So is this assumption that "3030C 5 4.9" is all in one cell.? My intent was to show that 3030C, 5, & 4.9 are in individual columns. jay

Narayan - I just noticed that I had Column A, B, and C spaced out as I typed my reply above, but it was condensed down when it posted. jay

Kyle - Thanks for the viewpoint. I follow your thoughts and it worked well in a test worksheet. My actual sheets are up to 30K + rows which I am trying to automate. As I learn VBA more, I may just try to record a macro that uses it. Regardless, I've never used TRIM, etc. Thanks to you and...

Narayan - Thank you for the follow up explanation. I changed the range and it worked like a charm. I would like to expand on what I just learned. With the orig data in column A, how could I have subsequent data in additional columns follow our expansion that the macro performs? I'm...

Narayan - The columns show activity when the macro runs, then all data disappears. Hmmmm... jb

Narayan- Whatever is simple is OK with me. I will learn VBA sometime; better with guidance than on my own. Yes - the data shown is as it is exported; LINE appears as I have it and the following digits (ABC or ABH in this case) will always be 3. There is a possibility of LINE LIN to which I...

I currently have a line header and associated numbers exported into excel in the same column. The following example is currently in one column. I need to separate and expand these into two columns. Example: LINE ABC 3030C 10026A 10026B 10026C LINE ABH 7595 7644 11146 16837 16838...

Is there a quick way of modifying this to count a range of endings? I tried wildcards * # ? with the 50 but to no avail. Currently just adding arrays to the sumproduct... in this case to add any ending in .50 and .51...

Everyone - Ended up using =SUMPRODUCT(1*(RIGHT(TEXT(Database!L$2:L$35491,"#.00"),2)="50")) when I was searching for anything ending in .50 in this example. jay

Everyone: Thanks for all the input. Everyone has been right - unfortunately I chose .99 to test everything - which seems to be a problem as Narayan pointed out. I re-ran the two original suggestions from Narayan and Hui for other endings - .09, .19, .29, .... up to .89. In all these cases...

NARAYANK991- Thank you. Without trying to change directions of the thread, the data I am using is exported from another program, and I do have to clean it up before I start working with it. My precision only requires 2 decimal places. Is there a quick way to cut off anything extra beyond...

Worked on using both formulas last night. Have two different answers. The sheet column i'm working with is 34K+ lines. All numbers - I am searching for the number of occurances that they end in .99 Using both methods I have different answers. I have verified formatted as numbers. I did a...

NARAYANK991 & HUI - Thank you. Just made my life easier & I am reminded that there is always more than one way to solve these problems. jay

Using excel 2010 and trying to count the number of occurrences of numbers with specific endings in a column. Column Example: 0.69 1.99 0.54 39.99 39.97 How many times does a number end in .99? If all went well the output would be 2. Been trying to use wildcards- but it doesnt seem to...