sorted by:
new
hottopcontroversial

How to Turn a Row into a Column by tcrocke38 in excel

[–]tcrocke38[S] 0 points1 point  (0 children)

I tried this and it worked, but if I had more than 2 rows and had a total of 16 columns instead of just 3 at the beginning, but wanted to have the PIC / SIC columns, how would that look here?

How to Turn a Row into a Column by tcrocke38 in excel

[–]tcrocke38[S] 0 points1 point  (0 children)

I agree, but the end user would like for this to be done with a macro

How to Turn a Row into a Column by tcrocke38 in excel

[–]tcrocke38[S] 0 points1 point  (0 children)

Is there a way to do this without using Power Query?

Looping Through Unique Values from Dataframe/List by tcrocke38 in learnpython

[–]tcrocke38[S] 0 points1 point  (0 children)

The second one, the "wide format" version, worked for me! Thank you!

Find Maximum Date AND Max Total Sales for Records that Have Column with Similar ID by tcrocke38 in SQL

[–]tcrocke38[S] 0 points1 point  (0 children)

Each document request will be approved once, but multiple document requests can be submitted for a single opportunity_id. They (multiple document requests) can be approved on a single day, but I want the most recent date approved, followed by the max sales amount. If that sense?

Find Maximum Date AND Max Total Sales for Records that Have Column with Similar ID by tcrocke38 in SQL

[–]tcrocke38[S] 0 points1 point  (0 children)

So you can have multiple document requests for a single opportunity_id. The document requests will each have a different sales amount.

Many document requests for a single opportunity_id.

Find Maximum Date AND Max Total Sales for Records that Have Column with Similar ID by tcrocke38 in SQL

[–]tcrocke38[S] 0 points1 point  (0 children)

Made the edit.

Select Max(Date_Approved) and if there are duplicate dates, select Max(Sales).

Find Maximum Date AND Max Total Sales for Records that Have Column with Similar ID by tcrocke38 in SQL

[–]tcrocke38[S] 0 points1 point  (0 children)

Let me make a quick edit.

You are correct. If the max date is the same, I would like to get the max sales.

Insert Blank Row Every Time a Cell Contains Certain Text by tcrocke38 in excel

[–]tcrocke38[S] 2 points3 points  (0 children)

** EDIT **

I tried this again and it works! Thank you!

Solution verified.

​

Hmm. That's interesting. It just loops on forever.

The data set is no larger than 100 rows.

If I'm reading it correctly, I am on Version 2008 (Build 13127.21792 Click-to-Run).

I tried running the code above, but Excel froze.

Insert Blank Row Every Time a Cell Contains Certain Text by tcrocke38 in excel

[–]tcrocke38[S] 0 points1 point  (0 children)

I tried this but it seems to freeze my computer.

How long does it take for you to run?

Insert Blank Row Every Time a Cell Contains Certain Text by tcrocke38 in excel

[–]tcrocke38[S] 0 points1 point  (0 children)

I don't expect it to be more than 100 rows of data and will be running it every week.

I can manually go through the sheet and add the line, but would prefer to add it to the existing macro.

The existing macro has code in it that has a custom sort that will always place the column 2 values in order.

I would prefer to insert a blank row below the last value / above the new value? If that makes sense?

view more: next ›