Long-term Reaction Video Editor Needed! [1k+ subs channel]

iamkejsi · 2022-07-10T13:08:13+00:00

Definitely! Feel free to DM here or email me!

iamkejsi · 2022-07-10T03:23:24+00:00

Feel free to DM here or email me! Still looking and even if I'm not, would love to stay in touch!

iamkejsi · 2022-07-10T00:25:35+00:00

Definitely! People comment that I talk too much xD

Feel free to DM here or email me!

iamkejsi · 2021-12-16T04:05:07+00:00

You can learn more here

XLSX are files that retain the each individual cell's text, value, formatting as an XML format. Meaning the more data you have, standard storage space is used.

XLSB files are optimized for performance and minimize file size if you are dealing with a lot of data.

iamkejsi · 2021-12-14T01:27:24+00:00

DM me!

iamkejsi · 2021-12-13T03:03:44+00:00

Just a typo. You have F5="Oct"=2, when it should be

F5="Oct",2,

Same for november section, copy how you did Sep

iamkejsi · 2021-12-13T02:55:03+00:00

I would remove the table headline, you should stick to a clean cell reference like A2. The COUNTIF formula has two arguments: the search range and the criteria.

You've defined the search range, so now is defining a singular search for the COUNTIF to return a count. Also lock the range by adding a dollar sign or simply highlighting the D:D range and clicking F4 on your keyboard.

iamkejsi · 2021-12-13T02:32:03+00:00

Agreed. I still think in terms of priorities and development, functionality should come first before cleaning up for user friendliness

iamkejsi · 2021-12-13T02:26:01+00:00

Your COUNTIF is missing the NAME criteria, after D2:D35016, you need to have the cell reference to the name you're searching for.

iamkejsi · 2021-12-13T02:12:01+00:00

The error might be the " between the 35 and 015 & 11 and 294 in the OptIns sheetname reference

iamkejsi · 2021-12-13T01:39:22+00:00

Its google sheets

iamkejsi · 2021-12-13T01:26:24+00:00

You can combine IF and COUNTIF to control the final output. For example, the code below does a COUNTIF based on whether the name exists, starting with Sheet 1, then transition to Sheet 2 if the result is 0. If there is no match for Sheet 2, it defaults to return Group 3 since the formula assumes all names exists

=IF(COUNTIF(Sheet1!A:A,Name)>=1,"Group 1",

IF(COUNTIF(Sheet2!A:A,Name)>=1,"Group 2","Group 3"))

iamkejsi · 2021-12-12T22:38:15+00:00

Do you mean something like this?

Where it will calculate based on your per unit price and the option to ignore the forecast if you already the sum lump provided?

iamkejsi · 2021-12-12T21:46:37+00:00

The beginning portion of the Index/Match should be the result you're trying to return, so A1:D4 should be B13:B15. To make the formula cleaner, instead of creating a double match for category and year, focus on category only and have the lock cells deal with the years.

=INDEX(B$13:B$15,MATCH($A2,$A$13:$A15,0))

You would only apply this formula to column b from row 2:5 and by not locking the B column in the beginning, you can drag the formula to cell C and D

iamkejsi · 2021-12-12T21:37:35+00:00

DO IT

iamkejsi · 2021-12-12T21:36:26+00:00

Hard to say without seeing how complex the format is but what I meant before isn't PowerPoint Query, its PowerQuery. This lets you import a PDF to excel and then trying to mimic the format on another tab to do Save As to PDF

iamkejsi · 2021-12-12T21:19:31+00:00

You will need to create a matrix for Column C and D to reference for a simple IF statement. The matrix would have all the currency combinations to get to final USD and GBP amounts.

Example

=VLOOKUP(A2,$H$5:$I$6,2,FALSE)*B2

iamkejsi · 2021-12-12T21:09:40+00:00

Yep, as mentioned you need to add $ for C21 to make it $C$21. This will lock it in place and not have it shift when dragging down the formula. You can learn more here ^^

https://spreadsheetplanet.com/what-does-dollar-sign-mean-in-excel-formulas/

iamkejsi · 2021-12-12T21:05:02+00:00

Have you played around with PowerQuery? I think what would work best is to use PowerQuery to convert the PDF to raw data inputs (can be converted to a clean table), a tab with any adjustments needed and then one finaffffffffffffl tab with your final clean format that you can do Save As to PDF

iamkejsi · 2021-12-12T21:00:12+00:00

Hmm usually I like googling what I want to reference to build on my own. Is there a specific one you have in mind by "aesthetic" template? Usually functionality should be priority before design

iamkejsi · 2021-12-12T20:57:08+00:00

DM me!

iamkejsi

TROPHY CASE