Dear Excel Gurus,
i came across a situation wherein i have to answer what Brands a user has.?
Please refer to attached file.
i have a user list with product brands owned by them. Now in the last columns (K in my data), want to get the Name of Brands a user has. (column K will update as soon a...
Hello There, i am stucked at one step.
i have a month wise data and wanted to sum only till the month selected by User.
ex. if a user wants a data only till Feb, then the sum should be only for 02 months, i.e. Jan and Feb.
Have attached a Sample excel file for reference.
Thanks in Advance...
Hello Everyone,
I have Incident Open Date & Time and Incident Close Date & Time.
I need to calculate the hours difference between these 02 dates & time.
It has some condition as below:
The hours difference calculated is only between morning 08:30 to evening 06:30. Difference counter stops as...
Dear Excel Savvy,
I have a Excel workbook with multiple worksheets in it.
And one worksheet named as “Summary”. In this Summary sheet all other worksheets are linked with formula. Ex. =Calc!F16.
Now the problem is, can I jump directly to the Cell in calc sheet from where the value in Summary...
Hi There,
I am using MS Excel 2010.
Whenever I create a Group on Rows, bydefault it adds a PLUS sign buttons on left side of Column A below to the selected rows.
I wanted to be added this PLUS button on the Upper side of selected buttons.
Reference to the attached excel file.
Have figured...
Hi All,
I have the Product wise Print Quantity data available that is to be printed either with Digital or Offset technology.
Any Quantity less than or equals to 99 to be printed Digitally AND any quantity Greater than 99 to be printed with Offset technology.
I have find out the Digital and...
Hi All,
I have an excel file wherein i have a rate card for the paper qty of different groups.
The Rates available with me are for group of qty like, 0-100, 101-200 etc.
The Rates are different for each group.
Can any one please help me with deriving the exact rate from the group of qty...
Hi All,
The problem I'm having is that when I click the scrollbar, it keeps scrolling all the way, to either the left or the right, instead of moving incrementally one by one.
I have set the incremental factor to 1, but it goes all the way as if I were continuously clicking the button.
This...
Hi All,
I have the machine serial number wise printed data on perticular Dates.
I wanted to have the machine serial number wise summary wherein, i could figure out the first and last date of printouts taken from the machine with count of prints.
Ex.
My data looks like:
Serial Number Print...