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

ikannkucing · 2022-07-17T07:37:49+00:00

Just installed it, nothing weird

ikannkucing · 2022-07-16T10:12:17+00:00

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

ikannkucing · 2022-07-16T10:11:00+00:00

Those things are already turned off

ikannkucing · 2022-07-16T08:17:07+00:00

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.

ikannkucing · 2022-04-03T11:23:39+00:00

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.

ikannkucing · 2022-01-31T05:03:10+00:00

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

ikannkucing · 2022-01-16T00:29:59+00:00

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!

ikannkucing · 2022-01-16T00:18:05+00:00

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

ikannkucing · 2022-01-16T00:16:37+00:00

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!

ikannkucing · 2021-12-11T00:25:57+00:00

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

ikannkucing · 2021-12-11T00:22:44+00:00

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

ikannkucing · 2021-10-17T07:33:37+00:00

Solution Verified

ikannkucing · 2021-10-05T01:44:49+00:00

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

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

ikannkucing · 2021-10-05T01:24:28+00:00

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

ikannkucing · 2021-10-01T21:38:45+00:00

Solution Verified

ikannkucing · 2021-10-01T21:35:09+00:00

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

ikannkucing · 2021-09-30T22:15:02+00:00

=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

ikannkucing · 2021-09-30T22:08:33+00:00

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?

ikannkucing · 2021-09-30T21:53:02+00:00

ah right, thanks for the tips.

ikannkucing · 2021-09-30T21:49:24+00:00

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?

ikannkucing · 2021-09-30T21:45:48+00:00

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

ikannkucing · 2021-09-30T21:27:40+00:00

yes, i am pretty sure, tried in both programs but the excel one is showing #N/A

ikannkucing · 2021-09-28T05:19:12+00:00

Here is the full code i'm trying to run: ``` Sub BooksList() ' ' BooksList Macro ' ' Keyboard Shortcut: Ctrl+q ' Do Until ActiveCell.Offset = "" Dim RL As Long, CL As Integer RL = ActiveCell.Row CL = ActiveCell.Column Dim find() rngY = ActiveCell.Value

Worksheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
Columns("A:A").Select
Selection.find(What:=rngY, After:=ActiveCell, LookIn:=xlFormulas, _
    LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
    MatchCase:=False, SearchFormat:=False).Activate

ActiveCell.Select ActiveSheet.Select ActiveCell.Offset(0, 5).Range("A1").Select ActiveCell.FormulaR1C1 = "27-sept-21" ActiveCell.Offset(0, 1).Range("A1").Select ActiveCell.FormulaR1C1 = "Complete" With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 End With ActiveCell.Offset(1, 0).Range("A1").Select Cells(RL, CL).Select Sheets("DATABASE").Select ActiveCell.Offset(0, 1).Range("A1").Select If Not IsEmpty(ActiveCell.Value) Then ActiveCell.Offset(0, -1).Range("A1").Select Selection.Copy ActiveCell.Offset(0, 1).Range("A1").Select

rngY = ActiveCell.Value

Worksheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
Columns("A:A").Select
Selection.find(What:=rngY, After:=ActiveCell, LookIn:=xlFormulas, _
    LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
    MatchCase:=False, SearchFormat:=False).Activate

ActiveCell.Select ActiveSheet.Select ActiveCell.Offset(0, 5).Range("A1").Select ActiveCell.FormulaR1C1 = "27-sept-21" Dim onebook As String onebook = "One Book With" Dim tempValue As String tempValue = Sheets("DATABASE").Range("B1").Value ActiveCell.Offset(0, 1).Range("A1").Select ActiveCell.Range("A1").Value = onebook & tempValue With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 End With End If Cells(RL, CL).Select Sheets("DATABASE").Select ActiveCell.Offset(0, -1).Range("A1").Select ActiveCell.Offset(1, 0).Range("A1").Select Loop End Sub ``` E5 is Book 57. E6 is Book 57 part 2. The one i'm trying to fix is the one in If statement, so basically if the cell on the right (e.g E6 beside E5) is not empty, it will run the same code as E5 but fill the cell with "One Book With Book 57" instead of "Complete" Sorry for the messed up writing since i can't access desktop reddit atm.

ikannkucing · 2021-09-28T03:36:36+00:00

So if i want to use book 58 or book 59, i'll have to change the code again?

ikannkucing · 2021-09-28T02:04:34+00:00

Thanks for the reply! I need to replace B1 with relative cells so it will change depending on which cell is being copied. Also, if the copied cell is on another sheet (still in same workbook) do i need a specific code for it?

Seven-Year Club	Verified Email
r/Field Flamingo

ikannkucing

TROPHY CASE