Results 1 to 6 of 6

Thread: Want excel formula for this .... problem

  1. #1
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default Want excel formula for this .... problem




    Mere pas ek excel ki workbook hai (jo ki attached hai) or usme 4 sheet hai jo ki ek dusre se link hai formula ke tahat.

    Ap mai ye chahata hau ke sheet no “mroll” mai “M” column mai jo jo row aa rahi hai or un rows mai jo bhi likha hai jese ke row no 1 mai hai “Surface dressing” or agli row mai jisme data hai wo likha hai “Excavation” to ye to mere row ke item ho gaye ap mai ye chahata hu ke jo mere 4th sheet hai “rate” ke nam se us me bhi tamab wahi item hai jo ke “mroll” mai hai ab mai ye chahata hu ke sheet “mroll” mai jo bhi mera item likha aaye to us ke age M column me us ke rate likhe aa jaye sheet “rate” se leke, kisi formula ke tahat , not manually.


    Aklmand Wo Hai Jo Mout Se Pehle Mout Ki Tayyari Kar Le

  2. #2
    Omer27's Avatar
    Omer27 is offline Advance Member
    Last Online
    30th January 2024 @ 04:01 PM
    Join Date
    27 Jan 2009
    Age
    32
    Posts
    1,725
    Threads
    72
    Credits
    1,374
    Thanked
    66

    Default

    Work book attach nahi hai

  3. #3
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default

    Shayad net pe proxy laga rakha he jis wazah se shayad file upload nahi ho rahi hai, lekin koi bat nai mai ap ko yahi samjha sakta hu ke mai kiya chahata hu—


    Jese ke sheet “mroll” mai column A mai ye items hai -

    1 Surface dressing
    2 Excavation
    3 Back filling

    Ab sheet “rate” mai hai

    Item Rate

    Surface dressing 18.00
    Excavation 62.00

    To ab mai ye chahata hu ke kisi formula ke tahat sheet “mroll” mai item no 1 ke aage ke column me sheet “rate” se usi item ka jo bhi rate hai likah a jaye

    Jese ke surface dressing ke agae 18 a jaye magar sheet \”mroll” mai

  4. #4
    syar is offline Advance Member
    Last Online
    19th September 2024 @ 03:04 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    887
    Threads
    10
    Credits
    579
    Thanked
    340

    Default



    Why not just use VLOOKUP OR INDEX MATCH formula your self?
    waise tu m bhee bata sakta hon lekan 1st try your self

    regards,

  5. #5
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default

    Quote syar said: View Post


    Why not just use VLOOKUP OR INDEX MATCH formula your self?
    waise tu m bhee bata sakta hon lekan 1st try your self

    regards,
    Sukriya bhai, apne itna hint to diya ap mei try karta hu agar hal nahi hua to fir preshan karuga Sukriya

  6. #6
    sohail1966's Avatar
    sohail1966 is offline Advance Member
    Last Online
    21st August 2024 @ 04:58 PM
    Join Date
    29 Sep 2011
    Gender
    Male
    Posts
    767
    Threads
    20
    Credits
    409
    Thanked
    40

    Default

    Nice sharing...

Similar Threads

  1. Solved excel formula problem
    By nissa in forum Solved Problems (IT)
    Replies: 5
    Last Post: 12th May 2015, 12:57 PM
  2. Excel Formula Problem
    By rafiquey in forum Ask an Expert
    Replies: 2
    Last Post: 12th August 2014, 08:04 PM
  3. Excel sheet formula problem...
    By Sarfraz Hussain in forum Ask an Expert
    Replies: 3
    Last Post: 19th June 2012, 09:59 AM
  4. Ms excel formula problem
    By princechand in forum Ask an Expert
    Replies: 10
    Last Post: 25th June 2010, 07:30 PM
  5. Excel formula problem
    By mcbtiger in forum Ask an Expert
    Replies: 3
    Last Post: 27th February 2010, 02:55 PM

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
  •