<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[一点一记]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/u014650178</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; u014650178]]></copyright><item><title><![CDATA[用有数据的单元格内容向下填充空白单元格]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/45486353</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/45486353</guid><author>u014650178</author><pubDate>Mon, 04 May 2015 21:31:08 +0800</pubDate><description><![CDATA[Sub fill
Dim i As Integer
For i = 1 To 10
If Cells(i, 1).Value = "" Then
Cells(i, 1).FillDown
Else
End If
Next i
End Sub]]></description><category></category></item><item><title><![CDATA[同类的多个数据合计]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/45486299</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/45486299</guid><author>u014650178</author><pubDate>Mon, 04 May 2015 21:30:28 +0800</pubDate><description><![CDATA[Sub classsum()
Dim i, j As Integer
For i = 2 To 122
If Cells(i, 1).Value 
b = i
Cells(b, 5) = Cells(b, 3)
Else
ActiveSheet.Cells(b, 5).Formula = Application.WorksheetFunction.Sum(Cells(i, 3), C]]></description><category></category></item><item><title><![CDATA[向下合并空白单元格]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/45486311</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/45486311</guid><author>u014650178</author><pubDate>Mon, 04 May 2015 21:29:11 +0800</pubDate><description><![CDATA[转别人的，但是忘记出处了
Sub SpecialMerge()
Dim M, N, i, j, k1, k2 As Long
Application.DisplayAlerts = False
k1 = 1
k2 = 1
With Selection
M = .Columns.Count
N = .Rows.Count
For j = 1 To M
For i = 1 To N]]></description><category></category></item><item><title><![CDATA[远程桌面控制台,有标签页可以管理多个远程桌面]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/43671917</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/43671917</guid><author>u014650178</author><pubDate>Mon, 09 Feb 2015 16:05:57 +0800</pubDate><description><![CDATA[Server 2003系统自带远程桌面控制台,有标签页可以管理多个远程桌面,在windows的其他系统如果要实现可以参照以下操作
1、将server2003系统C:\WINDOWS\system32目录下的mstsmhst.dll、mstsmmc.dll、 tsmmc.msc拷贝到当前系统中的C:\WINDOWS\system32目录下；
2、在开始菜单的运行栏注册dll文件：regsvr32]]></description><category></category></item><item><title><![CDATA[一个小脚本]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/33386809</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/33386809</guid><author>u014650178</author><pubDate>Sun, 22 Jun 2014 21:17:09 +0800</pubDate><description><![CDATA[#!/bin/sh
var=$(awk -F "|" '{print $1}' log)
echo $var;




#!/bin/sh
logmsg="bug|phone|buga|fklafkda"
var1=$(echo $logmsg | awk -F "|" '{print $1}' )
echo $var;






#!/bin/sh
logm]]></description><category></category></item><item><title><![CDATA[excel辅助选择群发邮件的邮箱地址]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/26509175</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/26509175</guid><author>u014650178</author><pubDate>Wed, 21 May 2014 21:31:35 +0800</pubDate><description><![CDATA[比如原有所有人员的名单]]></description><category></category></item><item><title><![CDATA[excel单个单元格变多个单元格合并]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/26508265</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/26508265</guid><author>u014650178</author><pubDate>Wed, 21 May 2014 21:14:18 +0800</pubDate><description><![CDATA[原始数据





1


2


3


4


5]]></description><category></category></item><item><title><![CDATA[excel定位--查找空值等]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/26507785</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/26507785</guid><author>u014650178</author><pubDate>Wed, 21 May 2014 20:59:02 +0800</pubDate><description><![CDATA[excel定位可以用Ctrl+g快捷键来调出，菜单就忘记是哪个了
定位有sh]]></description><category></category></item><item><title><![CDATA[excel数据透视表--整理汇总杂乱的原始数据]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/26487563</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/26487563</guid><author>u014650178</author><pubDate>Wed, 21 May 2014 16:44:49 +0800</pubDate><description><![CDATA[原始数据，xi]]></description><category></category></item><item><title><![CDATA[excel函数vlookup--查找需要的数据]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/26480465</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/26480465</guid><author>u014650178</author><pubDate>Wed, 21 May 2014 16:17:47 +0800</pubDate><description><![CDATA[vlookup用在大数据量查找时很方便，例如：]]></description><category></category></item><item><title><![CDATA[excel条件格式--根据数值来设置单元格格式，呈阶梯形效果]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/25875875</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/25875875</guid><author>u014650178</author><pubDate>Thu, 15 May 2014 10:55:23 +0800</pubDate><description><![CDATA[原始数据





 
 
 
 
 
 
 


 
 
 
 
 
 
 


 
 
 
 
 
 
 


2
4
6
8
6
2
4



目标效果]]></description><category></category></item><item><title><![CDATA[excel满足多个条件的个数]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/25875285</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/25875285</guid><author>u014650178</author><pubDate>Thu, 15 May 2014 10:38:38 +0800</pubDate><description><![CDATA[原始数据]]></description><category></category></item><item><title><![CDATA[excel条件格式-隔行变色]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/25874053</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/25874053</guid><author>u014650178</author><pubDate>Thu, 15 May 2014 10:29:07 +0800</pubDate><description><![CDATA[目标效果


=MOD(ROW(),2)=0]]></description><category></category></item><item><title><![CDATA[数据由单列或单行编辑成多行多列]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/25871899</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/25871899</guid><author>u014650178</author><pubDate>Thu, 15 May 2014 10:16:09 +0800</pubDate><description><![CDATA[以下例子由单列变成多行多列为l原始数据只有一列]]></description><category></category></item><item><title><![CDATA[Git rebase操作]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/24429207</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/24429207</guid><author>u014650178</author><pubDate>Thu, 24 Apr 2014 18:33:35 +0800</pubDate><description><![CDATA[1、git rebae -I
 
说明：对单个分支做rebase，将当前分支未push到远程服务器的提交做整理，就像把这部分提交拿出来逐条整理一遍，可以修改提交的文件，做增补提交，可以修改提交注释，可以合并到上一条提交，可以删除某条提交等。
 
图示：
 
                     E---F---G      
分支A
                     /]]></description><category></category></item><item><title><![CDATA[更改git clone时默认检出的分支]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/24416211</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/24416211</guid><author>u014650178</author><pubDate>Thu, 24 Apr 2014 15:27:48 +0800</pubDate><description><![CDATA[更改git clone时默认检出的分支


在git 服务器]]></description><category></category></item><item><title><![CDATA[Git 应用补丁时出现错误分析]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/24413195</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/24413195</guid><author>u014650178</author><pubDate>Thu, 24 Apr 2014 14:44:54 +0800</pubDate><description><![CDATA[git 应用补丁时出现错误提示


previous rebase directory *********** .git/rebase-apply still exists but mbox given.]]></description><category></category></item><item><title><![CDATA[Git补丁]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/24412927</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/24412927</guid><author>u014650178</author><pubDate>Thu, 24 Apr 2014 14:37:22 +0800</pubDate><description><![CDATA[1、创建补丁
 
1.1
git format-patch 
起始哈希值..结束哈希值  
说明：创建补丁，哈希值前开后合（起始哈希值对应的提交没有被包含）
 
如：分支图示：A---B---C---D---E
命令：git 
format-patch  C..E
结果：创建补丁文件D.patch和E.patch
 
1.2
git format-patch 
分支A ]]></description><category></category></item><item><title><![CDATA[cherry-pick的错误分析]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/24385303</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/24385303</guid><author>u014650178</author><pubDate>Thu, 24 Apr 2014 13:03:28 +0800</pubDate><description><![CDATA[在cherry-pick


# On branch
***
# You are currentlycherry-picking.
#   (all conflicts fixed: run "gitcommit")
#
nothing to commit,working directory clean
The previouscherry-pick is now empty, ]]></description><category></category></item><item><title><![CDATA[git merge 和 git rebase 区别]]></title><link>https://blog.youkuaiyun.com/u014650178/article/details/24356727</link><guid>https://blog.youkuaiyun.com/u014650178/article/details/24356727</guid><author>u014650178</author><pubDate>Wed, 23 Apr 2014 12:34:47 +0800</pubDate><description><![CDATA[git merge






git rebase]]></description><category></category></item></channel></rss>