Definitely not creating issue with my date just curious why. Really do appreciate your help
Posts by Billyrj
We will be implementing some important changes during 25th and 26th May 2024 which may result in an outage period of the website. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.


no issues on the original code. this is easy to manage just it was different and I was unsure why.

I have a quick question. What would cause at the end of the sheet additional rows of "99999999".
My data ends on row 156 and the macro rolls out an additional 4 rows of filling 99999999. This is much easier to fix just not sure why it would do this.

Perfect I was getting close and appreciate the help

Thank you and i obviously made it too hard. When I saw you formula the light when on.
thanks again

I am working a simple formula and have a pesky #value! Error. my formula is
=SUM(M4+L5)
If cells are empty I get #Value! error. I tried the following with no resolution
=SUM(IF(ISERROR(M4+L5),"",M4+L5))
My desire is to just have a blank cell is nothing in cells
thanks

Absolutely and appreciate all assistance and I have been given several options to work with.

Alan I too would like to thank you for power query direction. I have a lot to learn and truly appreciate your help and education

Carim,
I continue to struggle with pivot tables. works perfect if this is " ultrabasic Pivot Table" my skills are at the "Ultra Lite" level

Alan,
trying to elevate my knowledge of power query and definitely have a learning curve. I appreciate the help and will continue to learn this tool

Hello,
I have a file that has a large amount of data that if i could consolidate rows that meet the following criteria:
 ID Code matches in column "C"  this can be 3,5 10 25 rows of information
 in column "H" add the number in that meet this criteria of like ID Codes.
 in the like rows total the final Dollar amount in column "J"
I have a sheet with Raw Data that is split with blank rows only to show like rows. For separation purposes real data will not have blank rows. The final Result is what i am trying to accomplish. I would like to accomplish with a formula but unsure if it can be accomplished. Do i need to use a macro? I also tried a pivot table and could not get that to work either. Appreciate the Help.


Will do and working the combining pivot tables now and think i do not honestly know the best way to assemble data. does that make sense? So i continue to move between multiple pages and honestly think make one page and keep it clean. I am going to give this an honest attempt and will followup to make sure I post successful solution. really do appreciate your time.

Carim,
Thanks for the insight and apologize for my delay. I failed to explain some items on my example. My example was a result of 5 multiple pivot tables and the large spacing was charts i removed in the example. I recognize after looking at your example i can organize my data better and get the results i want easier.
would it be smart if i consolidate these 5 pivot tables? I get them from separate worksheets identifies as system engineering, Cost engineering...
if i do i will lose the grouping system engineering, Cost engineering. More work to do attempt to utilize your example and will follow up with my final solution. Again thank you for the learning time.

Carim,
Thanks for help I am using Excel 2016. I think you are correct on "Concatenated Text". Again thanks for you help.

hello,
I am working a project that i just cant seem to figure out a way to get proper results. I have a pivot table example::
1) I want to look in column "A" and Identify like names Like DOG which will end up multiple times and multiple names
2) If the name is DOG and if there is 1 in the row
3) copy Name and row label to the results sheet and there will be several labels over this document
How do i loop through the pivot table and get the names and pull the row label as well. Pretty big document and i have attached a sample size.
Thanks Billy J

I butchered it pretty bad and I made it a little complicated than I should Thank you for the assist. I will keep working on my syntax when working with tables.
Thanks again

I am working a spreadsheet that adds 60 days in column "I". The formula is looking into column "H" and adding 60 days easy enough. But if
"H" is blank i desire I to be blank as well. I attempted and ISBLANK formula but could not get it to work. I am new to creating and working with tables and unsure if that my misunderstanding on using ISBLANK.Thanks in advance
BillyrJ

Thanks this works and have been struggling on properly using tables getting better but never learned early on. My biggest issue is i will need to feed the range or manually change to provide best results. Thanks and really appreciate the assist.

Thanks works great. But I have a couple of questions.
1) why does M11 say 1/25/1925? I cant make sense out of that.
last question is probably more on the line with how to properly align a spreadsheet. I will have to change range ='Run Zones'!U8AVERAGE(I5:I10)
I5:I10 range will change quite a bit for data calculations. Approx 10K rows. I am unsure of a good dashboard setup. Any ideas will be helpful.
again thanks and works perfect

Have been working a spread sheet and have ran into a snag. I calculate the time between two dates and come up with years and months.
My problem now is I need to look at we will say 5 and figure out the average. The formula I used to calculate time between dates is below. How to I calculate the average between multiple dates on test sheet starting at T2. I was trying to create a calculation box but cannot figure a means of doing so. I am open to any ideas
Thanks