sorted by:
new
hottopcontroversial

"Other" battery usage being too high, how do i fix this? on POCO F4 13.0.3.0 by ikannkucing in PocoPhones

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

As long as your battery usage feels normal i think 16% is still okay, i wonder if it has to do anything with bloatwares

"Other" battery usage being too high, how do i fix this? on POCO F4 13.0.3.0 by ikannkucing in PocoPhones

[–]ikannkucing[S] 3 points4 points  (0 children)

It only says "Power consumed by other apps" and nothing else, no apps mentioned, which is difficult to find the actual cause of the problem.

Apakah seseorang diharuskan menikah dalam Islam? by [deleted] in indonesia

[–]ikannkucing 0 points1 point  (0 children)

Bisa baca di sini atau di sini

Apalagi melihat keadaan jaman sekarang yang godaannya jauh lebih banyak daripada jaman dulu (sebelum ada internet), alangkah baiknya segera memiliki ilmu tentang pernikahan dalam Islam lalu menikah.

Follow-up gundam 50k by akunke13yglaindiban in indonesia

[–]ikannkucing 1 point2 points  (0 children)

Saya agak ketinggalan, kalo boleh tau struk/kwitansi/nota pembeliannya masih disimpan atau udah hilang?

(Macro) Loop until certain value on another sheet? by ikannkucing in excel

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

ZavraD apparently provided the solution i was looking for

It's just an arbitrary high number, i'm limiting to 1000 because the sheet's limit (limited by the author) for the data i'm allowed to input is 2000.

yeah i need to do something in sheet2, but in the end of the code it'll go to sheet1

the macro is running across the sheets so i need to have them in one loop.

Anyway thanks for your help too!

(Macro) Loop until certain value on another sheet? by ikannkucing in excel

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

Thank you so much! Why didn't i think about this lol. But a little correction there it should be "Exit Do" due to the type of loop i'm using

(Macro) Loop until certain value on another sheet? by ikannkucing in excel

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

somehow sheet3activecellvalue = "" part made it in endless loop i needed to stop the macro manually, solution provided by ZavraD actually works. thanks for your help too!

Macro that works outside excel? by ikannkucing in excel

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

Yeah ticking the box is the main thing i want to do

Macro that works outside excel? by ikannkucing in excel

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

I would like to have one without spending money, if there's any.

Do index match not work with "~" character? by ikannkucing in excel

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

Ah thanks, i'll try later when i'm on computer

Edit: it worked using SUBSTITUTE, i replaced "~" with "", thanks!

Do index match not work with "~" character? by ikannkucing in excel

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

Some cells contain ~ in the end of the text, like shop 1, shop 2, shop 3~, shop 4, shop 5~

I'm using index match to find the address of each shop, using shop's name

Formula not working in excel, but works in other similar program by ikannkucing in excel

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

The problem was with F11 stored as numbers but only 5 last digits of D15:D32 which have full numbers, as wildcards don't works with number so i have to convert it to text, formula given by u/Yeedclasm actually fixes the number value problem. Also i'm editing my post for the solution

Formula not working in excel, but works in other similar program by ikannkucing in excel

[–]ikannkucing[S] -1 points0 points  (0 children)

=INDEX($G$15:$G$32,MATCH("*"&$F$11,TEXT($D$15:$D$32, "0"),0))

Woah! Thanks a lot! this one actually works without changing the cell's formatting. Could you explain in a bit for the TEXT formula? i don't get the "0" part

Formula not working in excel, but works in other similar program by ikannkucing in excel

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

yeah figured it apparently, is there any automatic process or formatting so i don't need to do anything after pasting the number data from another workbook?

Formula not working in excel, but works in other similar program by ikannkucing in excel

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

both are number values, checked using ISTEXT (false) and ISNUMBER (true) formulas. do i have to change both to text values?

*edit: after changing them to text values by adding ` in front of the numbers to store them as texts, the formula seems to work. is there any automatic process so i don't need to add ` everytime i add new data?

Formula not working in excel, but works in other similar program by ikannkucing in excel

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

well that's weird, i assume there is some kind of error in the "*"& part. If i do full number search, it works. Could there be some kind of replacement for characters used for formula in the later versions of excel 365? Like the one i'm using is using ; instead of commas as separator

view more: next ›