guys

Hi, May I know is it possible to remove "E+02" from 3.840000E+02 to become 3.840000? I know the value is before and after is different but is it possible? Hope you guys can help me.

Hi Guys can anyone explain to me what this formula is doing? the formula...

Hey Guys, I am new to writing formula. Can you guys help me with the below problem? Thanks. I want to write a formula in separate cells, where it shows the unique values of column A when a criteria is selected in Column B. Eg. Cell 1: good: 3 (101,101,103,103,105) Cell2: bad: 3...

Guys, I have the graph above and would like to create a little base between each cluster. Is that possible? If so, how? Thanks!

Hi guys! I'm embarrassed to have to ask this but when I exported some data to a CSV for some reason half the dates in the column is General format and not in Date format. I tried changing the format to date but it makes no difference at all. It is driving me insane =/ Any help...

I have this table... And i want to include a macro when click the "SAVE" buttom to do the following: Select the text in (E8:S8); Cut the VALUES only; Paste it in (E10:S10); As E8:S8 is some kind of input line, next time that want to save the information, the macro shall past the input...

Hi guys, i am very new to VBA. I have tried multiple codes from this forum and still can't get it to work. Appreciate if you guys can help me on the scenario. Scenario Example: Column N will be determine the last row e.g cell N10. Copy range will be from A1 until Z10 (based on last row of...

For example I want to count the number of "Y" in between cells with "X" highlighted some examples below: So basically I need to count "Y" only if there are cells with "X" before and after. Not sure if that is even possible in excel? You guys are the best, thanks

Hi All, very very new to power Bi. Can you guys help me from where I can learn easily power bi..

Hi guys, I have problems of round up function and would like to ask for help. I have a lot of data needed to be auto round up. 90,91,92,93,94 - all round down to 90 95,96,97,98,99 - all round down to 95 I have tried to search online and tried by myself in excel but couldn't find the solution...

Hi guys, For Each cellImp In hideRange If cellImp.Value = NoOfImpressionsBox.Value Then cellImp.EntireColumn.Hidden = False Else cellImp.EntireColumn.Hidden = True End If Next cellImp I've got a range ws.Range("BF4:BY4"), that gets pasted to a function. Both the value of...

Hi guys, Sorry for the poor title, i had no idea how to name such a simple task :rofl: I have a number lets say "10" stored in a variable. I want to split that variable into 2x multiplication table. 2,4,6,8,10. I need to do this via VBA, i will be adding the result to a combobox. In python i...

Hi guys, I'm having a very noob problem (i guess) with my graph where it doesn't display the right values. I'm probably doing it wrong, so could anyone, please, help me? Thanks in advance!

This is so far above my head I am wondering if you guys can help me! Columns A-D are what I want to refer to. DOG/MOM/DAD all have the same date ranges by week. Each combination of DOG/MOM/DAD and the dates of the week on or between column B & C receive a unique code which is in Column D. What...

Hi guys, I've got this spreadsheet i designed took me a very long time, however there is one major issue. It takes their Office365 name and populates a cell, the idea is it searches that name via filtering to find the user and displays his records. It works in the majority of cases, however...

Hi guys, I've got a forumla "=AZU5-AZT5", i've got a macro that inserts a column at the end of the macro i need to move the each side of the formula one cell right. =AZV5-AZU5 - will be the next location. I've got the complete macro ready, i just need to know how to shift forumla's across...

Hello guys, I have this colum with information: 908 34 89 908 How can I have excel show me how many duplicates of the same number (such as 908 in my example) are in this colum and maybe show me which ones are? Thanks!!

Hi guys, im trying to sum the amount im the chart below but i believe the {} is wrong that it only reflects the 1st criteria. Cell C5 =sum(sumifs(I:I,H:H,{"*P77*","*M41P*","*GO57*"},G:G,B5)) Scratching head.. thank you guys! <style type="text/css"><!--td {border: 1px solid #ccc;}br...

Hi, I cannot figure the formula logic for the following operation: <tbody> A B C CRT STATUS Desired Result 1 P1 P1 1 P1 1 P1 2 P2 P2 2 P2 2 P2 3 P3 P3 3 P3 3 P3 3 P3 </tbody> I have a count in column A, that is the same untill a value changes in B, like...

hi guys i have a pricing template that i want to implement to round up price points what's the formula please? <colgroup><col span="3"><col></colgroup><tbody> Between Round Up To $ 0.01 $ 0.27 $ 0.28 $ 0.29 $ 0.47 $...