Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rampure
  • Content: Threads
  • Order by date
  1. rampure

    To display the content of the cell

    Hi, I am trying to display the contents of the cell based on a condition. I have a state column,store column, two retails column of two months, say Jan and feb and a change column. Now i am trying to display the state based on the change column. If there is no change in retail, display the...
  2. rampure

    Using Count function when the data is filtered

    Hi, I have a huge data about 5000 rows. I have the filter on. Now I want to use the count and sum functions just for the filtered data and when I change the filter condition, the function should relect the change too. Thanks for your response in advance and I really appreciate the time. Smitha
  3. rampure

    Autofill - till data found

    Hi, I am using a couple of macros to automate in my spreadsheet. I need to copy the formula and fill the entire column till data is found. Right now, the macro is filling, but it is going beyond the data rows and filling in for the empty rows too. Can someone help me please. Thanks and...
  4. rampure

    Check a cell with a "X"

    Hi, This is my first day and first question here. I am trying to check a cell with a "X" if there is no data in the other cells. For example - if c5=0 or j5 = 0, then I want X in B5. I have this in the module. sub name() if(or(c5=0,j5=0),x,"") But this didn't work. Can someone help me with...
  5. rampure

    Check a cell with a "X"

    Hi, This is my first day and first question here. I am trying to check a cell with a "X" if there is no data in the other cells. For example - if c5=0 and j5 = 0, then I want Xin B5. Can someone help me with the steps? I am trying to write a module so it can be done automatically. Appreciate...

Part and Inventory Search

Back
Top