Search:

Type: Posts; User: Kamolga; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    11
    Views
    177

    Re: Code to get worksheet name into a cell

    You just need to save as since the formula is based on filename, then any calculation will update the value.
  2. Replies
    6
    Views
    225

    Re: SUM of cells that contain data

    Basically you just need to select 12 sheets (click sheet 1, press shift, then sheet 12) and type formula to have the count on 12 sheets. Sheet1:Sheet12 to have the count of 12 seets.
  3. Replies
    9
    Views
    212

    Re: Trying to obtain the ROI value for an investment portfolio.

    You are welcome, thanks for the feedback
  4. Replies
    11
    Views
    177

    Re: Code to get worksheet name into a cell

    =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
  5. Replies
    9
    Views
    212

    Re: Trying to obtain the ROI value for an investment portfolio.

    One thing could be that March is text. You need to enter it as 01/03/2019 and use format, more number format, select the last one 'custom' and Type "mmmm" (without " "). So you will read March but...
  6. Replies
    9
    Views
    212

    Re: Trying to obtain the ROI value for an investment portfolio.

    Hi, this would sum what is in column A if the date in column E is bigger or equal to 1st July 2019 and and smaller than 1st August 2019

    ...
  7. Replies
    9
    Views
    212

    Re: Trying to obtain the ROI value for an investment portfolio.

    Nobody can add an attachment to their post.
    There are tools to copy-paste excel, I installed an add-in for that but the simplest way is to use the snipping tool (installed with windows) to select...
  8. Thread: Probability

    by Kamolga
    Replies
    7
    Views
    225

    Re: Probability

    You are welcome. Thanks for the feedback.
  9. Replies
    6
    Views
    225

    Re: SUM of cells that contain data

    If you have columns A,b,c and rows 1 to 18, then your workdays are the amount of cells filled with data in range B1:C18

    =Count(B1:C18) will count it for you.
  10. Replies
    9
    Views
    212

    Re: Trying to obtain the ROI value for an investment portfolio.

    It is difficult to understand what your error could be since we have no data. Are A, F and J percentages? If so can you add them (all same base)? If not percentages, you miss brackets to get a...
  11. Thread: Probability

    by Kamolga
    Replies
    7
    Views
    225

    Re: Probability

    You need to first split your 3 criterias. Calculate how many females over total people. I would use
    countif(A1:A99;"Female")/count(A1:A99) formula if people sex was in column A, from row 1 to 99....
  12. Re: automatically delete empty rows when transfer data from userform to sheet1

    Dim lr As Long: lr = Cells(33, "C").End(xlUp).Row 'Last Row


    Range("A" & lr + 1, "E32").Delete
  13. Re: automatically delete empty rows when transfer data from userform to sheet1

    This checks what is the last row in column A above row 33, so lr =22 and then delete the range (A23:E32)


    Dim lr As Long: lr = Cells(33, "A").End(xlUp).Row 'Last Row
    Range("A" & lr + 1,...
  14. Re: VBA - Shared file. Two users with different versions of Outlook

    99% work on both (only a function created after 15.0 would not work on 15.0 and they are quite rare).
    What is annoying is that the outlook object library has to be activated on each computer...
  15. Thread: Access Query

    by Kamolga
    Replies
    3
    Views
    213

    Re: Access Query

    should give you the list of Agent that have CNG as supplier. You might have duplicate agents because every time it reads CNG in supplier, it gives the 'agent' value...not all the records but all the...
  16. Replies
    8
    Views
    127

    Re: Messy code problem

    I thing changing Textocolumn with split(expression,delimiter,[compare]) would reduce execution time. The best way is definitely to put in an Array and print it the way you want -> maybe use a...
  17. Replies
    8
    Views
    127

    Re: Messy code problem

    Rows("1:3").Select
    Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
    to

    Rows("1:3").Insert
  18. Replies
    8
    Views
    127

    Re: Messy code problem

    This is just a recorded macro...indeed needs a lot of cleaning. Anything finishing with
    .select and starting with
    Selection. should be united.

    Which line blocks?
    A dirty way is to start the...
  19. Replies
    1
    Views
    131

    Re: automating with merged cells

    Solved here https://chandoo.org/forum/threads/automating-with-merged-cells.41896/#post-249649
  20. Replies
    3
    Views
    152

    Re: Text formula - reverse word

    This is finally how I did it:
    Since the number of parts was variable, I had more ifs that I could handle. Instead I used VBA to split my string at each "
    " into an array. With Ubound I can...
  21. Replies
    3
    Views
    152

    Text formula - reverse word

    Hi,

    I face an issue with imported text over a few hundreds lines:

    One cell (A1) is like this

    Belgium BE Flanders VLG Antwerp Province VAN Arrondissement of Antwerp 11 Antwerpen 11002...
  22. Replies
    4
    Views
    100

    Re: Limit users to combobox list

    Create your MsgBox if something is left blank with focus to that place, so as a user you do not even need to look what is wrong...or simply use
    Application.DisplayAlerts = True after your line
  23. Re: VBA Help Needed - User form closed when other excel workbook is closed

    Application.DisplayAlerts = False

    ActiveWorkbook.Close

    Application.DisplayAlerts = True<strike></strike>
  24. Replies
    4
    Views
    100

    Re: Limit users to combobox list

    Maybe

    Application.DisplayAlerts = False
  25. Replies
    12
    Views
    318

    Re: number separation

    That is how I would do it:
    Put the values to split in A1, A2,A3, etc.
    Select the cells I want to split, then
    1.in data tab, click on Text to columns
    2.Select delimited and click next
    3.In...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4