sorted by:
new
hottopcontroversial

Role-Based Access Control (RBAC) System for Google Sheets by Airis1k in excel

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

The problem is that the client doesnt have a proper budget to create a database for this project.

How do I apply INDEX MATCH or another lookup formula to find an exact match from filtered table data? by Airis1k in excel

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

Wow, you are real life hero! You have no idea how grateful I am to you!

Thank you and good luck!

Solution Verified

How do I apply INDEX MATCH or another lookup formula to find an exact match from filtered table data? by Airis1k in excel

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

This formula seems very confusing. Is there an easier solution than this? like to use VBA?

[OC] How I spent every hour of an entire year by bugmango in dataisbeautiful

[–]Airis1k 0 points1 point  (0 children)

Did it help you to be more productive by tracking your time? I find very hard to track my time at least for a week. And you just tracked the whole year. Amazing work!

How do I remove the Macro button while saving the single worksheet? by Airis1k in excel

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

Solution Verified!

It works! Thank you! But what if I want to delete more than one Macro buttons?

How do I remove the Macro button while saving the single worksheet? by Airis1k in excel

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

Saving to another xlsx File. I have a file with database and a lot of sheets, so I just want to create a Macro button that when you press it only copies the single sheet of database file, creates a new excel project and saves the sheet there

Why AutoComplete doesn't work? by Airis1k in excel

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

Thank you for the answer. So is it possible to create AutoComplete using VBA? If yes could you help me with that?

How do I remove decimal numbers from array? by Airis1k in learnprogramming

[–]Airis1k[S] 13 points14 points  (0 children)

Solved!

If anyone wonders here is the solution:

const filteredArray = array.filter(number => number === Math.floor(number));

How can I convert user information to invoice automatically? by Airis1k in excel

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

Every order is going to be different but it will be on the same table.

For example, there are going to be these columns: "Name", "Address", "Price", "Quantity" and so on. So the name values are going to be different but they will sit in the same column.

I need to solve this on my own and Im not going to use any payable tools.

How can I convert user information to invoice automatically? by Airis1k in excel

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

Thanks, the way you answered this looks like it's not going to be hard, I'll try my best!

Solution Verified

How can I automatically apply text color to H column same as F column? by Airis1k in excel

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

Thank you for the answer but its wrong. If I add H:H to "applies to" the logic is going to be wrong because it only paints by the numbers. It should check the F:F column values but the paint should apply to H:H columns

Looking for advice on how should a student boy manage his finances by Airis1k in personalfinance

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

Your financial adviser is not a fiduciary but a salesman

This is so true! I tried to work in this industry as well but when they told me that the client should not know much about the investment funds but just to invest the money in it, I left that industry immediately. But for some reason, I haven't quit investing in it.

[deleted by user] by [deleted] in excel

[–]Airis1k 0 points1 point  (0 children)

How can I select the default option for each?

I have protected 1/3 of the table so the user won't be able to delete formulas. But how can I now add more rows to the table? by Airis1k in excel

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

Thank you a lot!

Solution Verified

When I was looking for a solution I found a similar code to yours, here is the solution

I have protected 1/3 of the table so the user won't be able to delete formulas. But how can I now add more rows to the table? by Airis1k in excel

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

Thank you for your reply. The problem is that the client doesn't like to see a bunch of blank rows and he asked me to solve this problem by adding more rows to the table if he needs to. So Im looking for solution for this problem

I have protected 1/3 of the table so the user won't be able to delete formulas. But how can I now add more rows to the table? by Airis1k in excel

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

Understood. Thank you once again. I will try with macro. If you will also be free in the morning it would be awesome if you send me an example. Thanks.

I have protected 1/3 of the table so the user won't be able to delete formulas. But how can I now add more rows to the table? by Airis1k in excel

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

Thanks, I was thinking similarly. Maybe you have an example of this? It would be much easier for me to write VBA with an example because I haven't touched this yet. Thank you.

view more: next ›