Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. How to read approx 200 excel file in a single excel sheet one by one.

    Dear All,

    I have a folder named transaction that contains approx 200 excel file. the excel file name is e.g 19875 , 23,456,1450 etc.
    I want to copy all excel file data in a single excel file one...
  2. Replies
    5
    Views
    284

    Assistance required

    Dear All,

    I have an excel sheet of text string like....
    Cell A1 .... employee_code = 25147 and trans_code=16....
    Cell A2 .... employee_code = 25112 and trans_code=16....
    Cell A3 ...
  3. Request for a macro in outlook 2016 that fetch all email sent from 01 Dec 2018 to 31 Jan 2019 from inbox or sent items.

    Dear All,
    Good Day !!!

    I would like to pull all those email from outlook 2016 in a folder in my system that i had sent email from 01 Dec 2018 to 31 Jan 2019 by Outlook VBA code.
    some email is...
  4. Replies
    4
    Views
    187

    Modification regarding EOMONTH function

    Dear All,

    =""&EOMONTH(DATE(2018,12,1),0) return 43465 last day value
    But i want the last day value return as 43465.9993055556 value date
    SoI modify in this formula=""&EOMONTH(DATE(2018,12,1)...
  5. Replies
    3
    Views
    169

    Re: Modifying Formula

    Sir, It won't give the result.
    The excel cell consists the value
    <colgroup><col></colgroup><tbody>
    12/4/2018 14:09


    12/31/2018 4:50


    12/31/2018 15:09
  6. Replies
    3
    Views
    169

    Modifying Formula

    Dear All,
    Please modify the highlighted bold formula that gives the result in such a way.
    ...
  7. Excel won't recognise as date ( mm/dd/yyyy)

    Dear All,

    The attached excel sheet have date value in different cells , But excel won't recognise as date , So i want all cells date value recognise as a date value in (mm/dd/yyyy) format.
    ...
  8. Value return based on match particular text.

    Dear All,

    Please assist me in finding the solution..
    I have a column C2:C4156 that contains different text paragraph,I want to match the text based on following condition.
    1. if text , "PUMP" OR...
  9. Replies
    7
    Views
    186

    Re: Correction require

    Cell Value
    B5 :7779
    B6 :8642
    B7 :9180
    B8 :9785
    B9 :10470
    B10 :11130
    .........
    ..........
  10. Replies
    7
    Views
    186

    Re: Correction require

    One more condition included.
  11. Replies
    7
    Views
    186

    Re: Correction require

    I have CELL B6:B520 which contains numerical value . if any cell value become >=15000 or <=15500 and again >=20000 or <=20500 then cell H50 gives a alert SERVICING or pop up a MESSAGE FOR SERVICING.
  12. Replies
    7
    Views
    186

    Correction require

    Dear All,

    Can i make a condition for range of cells in and function, Correction require in below function
    =IF(AND(B6:B525>=15000,B6:B525<=16000),"SERVICING","Change Oil after every 2500KM")
    ...
  13. Replies
    2
    Views
    188

    Assistance Required

    Dear All,


    I want a function that help me to retrieve data in following conditions.
    Cell date Format is mm:dd:yy hh:mm:ss. Cell Value is in col K2.
    if date column match in between date range...
  14. Replies
    3
    Views
    107

    Re: Return cell values as date

    Desired outcome either 7/7/2018 or 14/07/2018 or 21/07/2018 or 29/07/2018
  15. Replies
    3
    Views
    107

    Return cell values as date

    Dear All,


    I want a formula in excel for following problems.
    I want to match values available in colH 001,014,015,GH1 and return a random date in between date (eg...
  16. Replies
    1
    Views
    156

    In Pivot table settings

    Dear All,

    I changed the pivot data settings. But after refresh it resume its original position.
    How does change so that after refresh it wont affect changed format.

    Any assistance !!!

    Rgds,...
  17. Based on multiple same column data i want to retrieve only unique data row records

    Dear All,

    I want to keep only unique records based on column J data. Since Column J has multiple same data .
    I want to keep only one record and same data shold be deleted.

    Any Help,
    ...
  18. How to extract any character / or alphanumeric among out of 20 alphanumeric character in excel sheet.

    Dear All,

    How to extract any character / or alphanumeric among out of 20 alphanumeric character in excel sheet.

    For e.g. out of 20 alphanumeric i want to extract character no 10 , 11 , 12.
    ...
  19. Replies
    2
    Views
    145

    Re: Column Chart Regarding.

    Dear jarjarbingie,

    I tried but didn't get result. my problem is like this. Y- Axis (Vertical) 0%, 10%,20%,30%,40%,50% X- Aixs (Horizontal) - Jan , Feb , March, ........Dec.

    I want to give...
  20. Replies
    2
    Views
    145

    Column Chart Regarding.

    Dear All,

    I have a column chart with different percentage. I want to give a thresold horizontal line in a chart 20 % and 10 %.
    Any help or suggestion.Regards,

    Aligahk06
  21. How to increase size of Check box in excel sheet

    Dear All,

    Could u plz assist How to increase size of Check box in excel sheet?

    Any help,

    Rgds,
    aligahk06
  22. Re: Converting Each Column cell Mobile Number to in one cell separated by semi colon.

    What would be solution for this kind of problem.
  23. Converting Each Column cell Mobile Number to in one cell separated by semi colon.

    Dear All,

    I have a excel sheet containing mobile number from A3:A4500. I want to each mobile number separated by ; in one cell B3.
    ex: 9856231212;586452124;....... and so on ...


    Rgds,
    ...
  24. Replies
    2
    Views
    147

    Converting the round figure ....

    Dear All,
    I have a value in excel column in this way 2514.12, 3001.85, 2514.49 and so on vertically. I want the round figure in same cell like 2514, 3002 ,2514 . The cell only show round figure...
  25. Any Add in that converts excel file to pdf .( Office 2007 version)

    Dear All,

    Any add-In that can convert my excel sheet and word file to pdf.

    Plz help us

    Rgds,
    Aigahk06
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4