Hi Team,
curious to know.. how VLOOKUP works.. or whats the flowchart to get the answer..
When data is not sorted.
Range LookUp set as TRUE.
https://dl.dropboxusercontent.com/u/78831150/2014-08-16_0933.swf
Hi Team,
Two parameter : CSAT Survey Count & CSAT Average Score,
I want to plot Count as Column Chart (Primary) and Average as Step Line Chart (Secondary).
So that I can show the Customer Satisfaction level more clearly.
Just a glimpse below.. how the final chart should look like..
PS...
I have created a customized user form.. nothing just company logo at top right and theme color for form.. and a company hyperlink.
Saving the frm file.. and import everytime is not a big task.. but.. just like sheet1 / book1..
is there any default location to save the frm file..
So that...
Congrats.. buddy.. @Somendra Misra
Thanks for all support & effort to this forum..
Congratulation Debraj
For completing 1year as a Ninja.. :)
http://chandoo.org/forum/threads/congratulations-debraj-excel-ninja.10622/
PS: @myself.. work hard.. you are too slow.. :(
Hi Forum,
Can someone, help me to create a Drag-able Formula for the below situation.. :(
PS: No.. you are wrong..
MERGE CELL is most important thing in the world to LIVE..
Hi Folks!
Today I faced a weird excel file (xls)
When I tried open, it says.. "The file type you are trying to open is not recognizable.... would you like to recover..!"
Then its open normally..
but I cant copy anything from this file.
If I open a new workbook.. and tried to lookup.. like =a1...
Hi Team.
Lets say, I need to demonstrate Productivity of a member.
* In Jan-13, he was working on approx 5 reports, and he is taking avg 7 hour to complete all the reports.
So, I have his, # of Report and Total time taken.
As his experience increase, Now he is working on approx 8 reports, but...
I am planning to learn some analytical skill.. :oops:(frankly speaking.. my company wants/forcing me to go for it.. :( )
Although, in term of regression, co-relation, histogram.. i give them better output than my colleagues having knowledge of R / Minitab.. still.. if any one here from...
Hi forum,
I don't know, is this problem in my system, or its with other also..
My object's on the sheet are changing its size,
Can anyone, suggest me any properties, to set objects Widsth & Height fixed..
All goggling are showing code to set Width & Height in worksheet change or sheet...
Hi Folks,
Hope you may find it interesting.. :)
Just few basic Math calculation.. and few use of plotting right AXIS on RIGHT side.. and secondary Plot to match accordingly..
Let me know, if you find it interesting and need more details..
PS: looking for your suggestion.. on how to make...
Hi Forum,
Need a 100% Stacked Column Chart
Need to add data label like 40% & 60% for each series
Need to Display Total No Of Post in Right Axis or Secondary Axis
PS: Feel free to change chart type.. If required.
Sample file 7 expected Output attached..
Hi Team,
Is this possible to select
* Special Cell > Formula > Contain ArrayFormula.
I mean something like..
if left(.formula) = "{" then IsArrayFormula = True
For example, If A4 = "=SUM(A1:A2)"
and A5 = "{=SUM(A1:A2)}"
then I want to select A5 only..
Hi Forum,
How to align User Form Caption as Left Alignment..
Actual :
Expected:
I have seen, few form's caption as Left Alignment.. but which property need to change...
PS: obviously, Expected Image is activated by Photoshop :)
Do we have any participant... then
BEST OF LUCK
You can share.. your.. thought or preparation or expected question.. in this thread..
____
for more detail visit
http://www.modeloff.com/
____
ModelOff competitors will first battle it out in Round 1, a 2 hour online contest held simultaniously...
[list type=decimal]
To all.. for posting your queries.
To all.. for giving huge range of validation & combination to play with.
To all.. for giving countless types of Excel Question.. to solve.
To all.. for showing solution for a single problem.. with many ways.
To all.. for showing each...
Hi Excelian,
Can someone please help me to write any EVALUATE function.. with Ctrl + Shift + Enter..
i.e..
Sub EvaluateWithCSE()
Set SD = ThisWorkbook.Sheets("SalesData")
lr = Cells(1, 1).CurrentRegion.Rows.Count
lc = Cells(1, 1).CurrentRegion.Columns.Count
'----
'Want to...
NO THIS IS NOT A SPAM...
Holi is an ancient festival of India and was originally known as 'Holika'.
Legends and Mythology
In some parts of India, specially in Bengal and Orissa, Holi Purnima is also celebrated as the birthday of Shri Chaitanya Mahaprabhu (A.D. 1486-1533). However, the...
Hi Excelopedians,
Can someone please help me to create a drag-able FORMULA to get Margin.. via multiple Condition..
* Each Vendor has only one type of MARGIN decider (MRP or BRICK or TAX Code)
* According to Margin decider, I need to get MARGIN for the VENDOR..
i.e Vendor 1 (Chandoo) 's...
Hi Friends,
Can someone help to create a Formula, for repeating Items a Specific Number of times, in loop..
Z 5
Y 2
X 1
W 4
then Z 5 Times, Y 2 Times.... but in series
expected output
Z
Y
X
W
Z
Y
W
Z
W
Z
W
Z
Regards,
Deb
PS: Cross-post @...
Hi Folks,
Can anyone have any Tweak or RegEdit to set Default Find > Option > Within > Workbook..
I mean.. is there any option to
set Application.Find("Something", LookAt:= xlWhole) .. as default for my system..
Its really annoying to set Search Within Workbook...
Hi Friends,
I am unable to select Multiple Sheets at once. I don't know, where I am missing something, but its just ruining my day :(
Main Problem is in ShtAry (Array Of Sheet). Its adding Sheets to array. I can check the same at Immediate window by ? ShtAry(78).Name
But Unable to select...