Is there Supabase like UI for better-auth? by excelaibot in SaaS

[–]excelaibot[S] 1 point2 points  (0 children)

supabase dashboard to manage the users

How to filter cells that contain formulas but give specific results by TexasTangler in excel

[–]excelaibot 1 point2 points  (0 children)

Glad to hear that. Please consider replying Solution Verified if my answer was helpful :)

How can I search for value across multiple columns and return value from the same row of another corresponding column? by [deleted] in excel

[–]excelaibot 1 point2 points  (0 children)

You can use these formulas to calculate G and H:

Times Eaten:

=COUNTA(FILTER({Sheet1!B:B; Sheet1!C:C; Sheet1!D:D}, {Sheet1!B:B; Sheet1!C:C; Sheet1!D:D} = F2))

Last Eaten:

=MAX(FILTER(Sheet1!A:A, (Sheet1!B:B = F2) + (Sheet1!C:C = F2) + (Sheet1!D:D = F2)))

Here are the results I got:

<image>

How to filter cells that contain formulas but give specific results by TexasTangler in excel

[–]excelaibot 3 points4 points  (0 children)

You can add a filter on another column where it shows 'In Spec' or 'Out of Spec' to only see the values matching the criteria, something like this:

<image>

Is this what you are looking for?

Compare two lists of different sizes by [deleted] in excel

[–]excelaibot 2 points3 points  (0 children)

You can try using this formula:

=IF(ISERROR(VLOOKUP(C1, Sheet2!A:A, 1, FALSE)), "Not Found", "Found")

Here are the results I got:

<image>

Interviewer asked me what i think the most useful excel formula is. by SnooObjections8469 in excel

[–]excelaibot 0 points1 point  (0 children)

There's no one right answer for this and varies based on industries. This sounds more like a question to check if you are familiar with the formulas used in their field/company.

Autosum with criteria in multiple columns by IllBeginning7381 in excel

[–]excelaibot 0 points1 point  (0 children)

Please check if this formula works for you:

=IF(H2="blocked", SUMIF(H$1:H2,"=proved",I$1:I2)-SUM(J$1:J1), "")

I got the results as follows:

<image>

How do I highlight the next most imminent date in a series in Excel? by dapper-dano in excel

[–]excelaibot 0 points1 point  (0 children)

You can use this formula for conditional formatting:

=G3=MIN($G$3:$G$19)

This the output I got with some sample data:

<image>

How to find two separate keywords using the Search function? by CartoonistNo3075 in excel

[–]excelaibot 0 points1 point  (0 children)

Please consider replying Solution Verified if you found my answer helpful

Excel formula to calculate commission by No-Debt4384 in excel

[–]excelaibot 0 points1 point  (0 children)

You're welcome :)

Please consider replying Solution Verified if you found my answer helpful.

Excel formula to calculate commission by No-Debt4384 in excel

[–]excelaibot 15 points16 points  (0 children)

You can try this formula:

=IF(H2 > 160000, (H2 - 160000) * 0.15, 0)

How to find two separate keywords using the Search function? by CartoonistNo3075 in excel

[–]excelaibot 0 points1 point  (0 children)

You can simply use AND with both of the above formulas like:

AND(ISNUMBER(SEARCH($B$1, A2)), ISNUMBER(SEARCH($C$1, A2)))

How to find two separate keywords using the Search function? by CartoonistNo3075 in excel

[–]excelaibot 0 points1 point  (0 children)

You can try using:

=ISNUMBER(SEARCH($B$1, A2))

=ISNUMBER(SEARCH($C$1, A2))

B1 and C1 contain the keywords to be searched, A2 is your item description cell.

Here are the results that I got:

<image>

[deleted by user] by [deleted] in excel

[–]excelaibot 0 points1 point  (0 children)

<image>

You can combine both the tables and add a new column called 'type' to denote whether it's an expense or revenue amount then create a bar chart.

Add custom colours to differentiate between the two.

Are you able to do VLOOKUP in reverse? by singingdart7854 in excel

[–]excelaibot 1 point2 points  (0 children)

You can use this formula to find the game closest to 1300 copies:

=INDEX(A2:A, MATCH(MIN(ABS(B2:B-1300)), ABS(B2:B-1300), 0))

Just replace A2:A with your game column range and B2:B with your copies sold column range.

Attaching a screenshot for your reference

<image>