Sibeesh Passion

Find The Existence Of A String In Other Column

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this post we will see how we can find the existence of a string in other columns in Excel. We will be using a single excel formula to do this task. I hope you will like this. Here we are checking the value of B2 cell is existed anywhere in column A. If the […]

Read More

How To Show Or Hide Columns In Excel

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         Introduction In this article we will learn how we can show or hide columns in excel. I hope you will like it. Background Today I was working in a Report that I am maintaining for myself . It actually contains my debit/credit details of a month. And I was in a need of hiding a […]

Read More

Transpose Row Values To Column In Excel

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         Introduction In this article, we will see how we can transpose or change row values to column in EXCEL. I hope you will like it. Background Today when I was just analysing my grid data in office, I just copied some of the conditions in the grid, Since all of the values were in row, […]

Read More
Footer With Address And Phones