+ Reply to Thread
Results 1 to 6 of 6

arrange result to exact row

  1. #1
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    arrange result to exact row

    Rearrange (Formula) is expected to show results in the right line.
    As shown in Excel the formulas search incorrect coordinates.

    Thank you,
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: arrange result to exact row

    The values have 2 decimal places.
    The format you have chosen has zero decimal places.
    Reformat the cells to show the correct value.

    And I think you need to explain your problem in more detail.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    Re: arrange result to exact row

    Sir, I'll find out accidentally typing the number

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,426

    Re: arrange result to exact row

    In C4

    =IF(ISNUMBER(A4),IF(AND(LEN(INT(A5))<>LEN(INT(A4)),LEN(INT(A4))<>LEN(INT(A3))),"wrong",""),"")

    Copy across to D

    And down

  5. #5
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    Re: arrange result to exact row

    Thank you sir but I Need result looking a column "E" and "F"

  6. #6
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    Re: arrange result to exact row

    Sorry sir, I accidentally put it on C3, formula works correctly.
    Thank you so much,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. To Sort exact and partial exact match for a single column.
    By Jagdev in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2014, 05:08 AM
  2. Formula not showing exact result
    By karthikgmk in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-10-2014, 03:04 AM
  3. Exact result when s specific Item is chosen
    By managingcrap in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-19-2014, 12:46 AM
  4. Exact result when s specific Item is chosen
    By managingcrap in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-18-2014, 01:46 PM
  5. get exact result from a series of numbers
    By alexistkd in forum Excel General
    Replies: 11
    Last Post: 11-01-2013, 06:19 PM
  6. [SOLVED] Vlookup formula returns with False Result, How can I get the exact value ?
    By Midoya in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 02-21-2013, 04:34 AM
  7. Change the fill color of a cell as a result of EXACT
    By Screamtruth in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-03-2010, 09:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1