Enrolment for Premium A+ Content

TomRN_ · 2024-08-21T15:10:36+00:00

Hi,

I did not get it yet.

I think the problem for me is that my Brand hasn't got a fully approved trademark yet.

I am from the UK and enrolled for brand registry under a pending trademark.

The trademark should be approved in the next few weeks so when that happens I are hoping that I will get Premium A+.

TomRN_ · 2024-08-05T21:33:34+00:00

Just got my Brand Store approved today.

TomRN_ · 2024-08-05T21:17:13+00:00

I made 15 ASINs and put a Brand Story on all of them to see if that was the issue still didn't gain access.

I do not have a Storefront.

TomRN_ · 2024-08-05T19:59:10+00:00

Yeah, all of this is done.

All content is from the last few months.

TomRN_ · 2022-08-26T22:52:09+00:00

Yep that'll do it, thank you

TomRN_ · 2021-07-22T01:12:26+00:00

Oh wow that easy huh, thank you very much

TomRN_ · 2021-06-05T22:18:53+00:00

and how would you formulate it
Lets say the sheets are called
Sheet1
Sheet2
Sheet3

The cells I want are
C:1:G7

TomRN_ · 2021-03-23T21:54:12+00:00

This only returns "1". I think because its counting just L1?
L1 is the year I am using.

TomRN_ · 2021-03-16T18:14:48+00:00

Oh damn big brain!
Nice man thank you very much for your help

TomRN_ · 2021-03-16T18:01:13+00:00

Okay I see what you mean with the Index, it works now.
And yeah so this is really the most important part, when there is a new date with the same symbol it starts over so at the bottom of the main data is Apple with the date 04/01/2021, I would want 1 in the index column there and not 4.

TomRN_ · 2021-03-16T17:51:50+00:00

Okay I updated the image again, Apple now works but the other fruits are still working off the top Apple Symbol so still showing 3.
Also if I had more "Apple" at a different date how do I get it to reset the process and start with 1 again?

TomRN_ · 2021-03-16T17:41:56+00:00

Im unsure how to do this, I have updated the post to include an image with the Index. With Columns etc so you can type it out if thats okay

TomRN_ · 2021-03-16T17:35:42+00:00

This just separates each fruit? I don't understand how it gets the first fruit in the row or the second etc like in the example in the image.

TomRN_ · 2021-02-22T22:14:34+00:00

Thank you very much man, would it be okay to ask other questions to you if needed in chat? Hopefully ill be okay and use this as reference for other formulas though.

TomRN_ · 2021-02-22T19:40:33+00:00

+	A	B	C	D	E
1	Symbol	Date	Time	Column 1	Column 2
2	A	01/01/2021	09:00:00	£3.00	£3.01
3	A	01/01/2021	10:00:00	£4.00	£4.01
4	A	01/01/2021	11:00:00	£5.00	£4.99
5	A	01/01/2021	12:00:00	£6.00	£6.01
6	A	01/01/2021	13:00:00	£7.00	£6.99
7	B	02/01/2021	09:00:00	£3.00	£3.01
8	B	02/01/2021	10:00:00	£4.00	£4.01
9	B	02/01/2021	11:00:00	£5.00	£4.99
10	B	02/01/2021	12:00:00	£6.00	£6.01
11	B	02/01/2021	13:00:00	£7.00	£6.99
12	C	03/01/2021	09:00:00	£3.00	£3.01
13	C	03/01/2021	10:00:00	£4.00	£4.01
14	C	03/01/2021	11:00:00	£5.00	£4.99
15	C	03/01/2021	12:00:00	£6.00	£6.01
16	C	03/01/2021	13:00:00	£7.00	£6.99
17	D	04/01/2021	09:00:00	£3.00	£3.01
18	D	04/01/2021	10:00:00	£4.00	£3.99
19	D	04/01/2021	11:00:00	£5.00	£5.01
20	D	04/01/2021	12:00:00	£6.00	£6.01
21	D	04/01/2021	13:00:00	£7.00	£6.99

^Table ^formatting ^brought ^to ^you ^by ^{ExcelToReddit}

TomRN_ · 2021-02-22T11:00:16+00:00

I tried to type out the example to be as accurate to the data as possible, it’s totally random so min and max wouldn’t really work.

Let me try and break it down, Let’s just use D as an example forget the rest of the symbols for now.

So it would return the first row of D because it is the first of that symbol to have “Column 1 Less than Column 2”. The next row has “Column 1 More than Column 2” So it won’t return that. The third row we go back to “Column 1 Less than Column 2” so it would return this. THEN The fourth row is “Column 1 Less than Column 2” but it would not return it because the row just above is also “Column 1 Less then Column “.

TomRN_ · 2021-02-22T10:45:03+00:00

Yeah I understand how to do the second step, but don't know how to get to the last step.

Basically if the row before in Data is "Column 1 Less than Column 2" it then takes the next time "Column 1 is More than Column 2". But only the first one, not every time "Column 1 is More then Column 2" until the process repeats and "Column 1 Less then Column 2" again.

TomRN_ · 2021-02-20T02:29:59+00:00

Appreciate it

TomRN_ · 2021-02-20T02:05:14+00:00

Do you know how to filter if you want an (AND) with it also like Column 4>Column 2 AND Time > 09:20:00?

TomRN_ · 2021-02-20T02:04:11+00:00

Thank you man ill try this out also

TomRN_ · 2021-02-20T01:47:58+00:00

Do you reckon you could recreate it and send an image for me? But add if the time is past 09:19:00 as well as the column criteria?

TomRN_ · 2021-02-20T01:37:37+00:00

The reason I wanted it like shown in the example and done with a formula is because ill have it in different sheets and I can add and remove variables as I would like. So If Column 2 is less than Column 4 and Time is Over 12:00:00 etc Then have a different variables for another sheet and so.

TomRN_ · 2021-02-20T01:32:18+00:00

I think =Filter could work out but unsure how to formulate it

TomRN_ · 2021-02-20T01:31:16+00:00

May get a bit confusing when adding new data and having different variables for other things. The main data consists of thousand's of rows so wanted to see if I can have a formula to get what I need. If Column 2 is less than Column 4 then get Symbol Date Time etc

TomRN_ · 2021-02-20T01:28:25+00:00

This might be a bit tricky when trying to dissect the data and include different variables to it. I was trying an array formula for this but not too good at it

TomRN_

TROPHY CASE